Re: Getting a file to excel

When downloading credit card numbers to Excel, one trick is to concatenate a 
pound sign to the credit card field, using an SQL select statement:

select teid, concat('#',tecc) from ccfile

Excel assumes the value is a character field when prefixed with the pound sign.

If you'd like to send me a private email, I can send you a V5R1 *SAVF of my 
SQL2STMF command, which generates stream files (including CSV files) from SQL 
select statements.  CSV files can be read by Excel.

Nathan M. Andelin





----- Original Message ----
From: Alan Shore <AlanShore@xxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, June 28, 2006 2:01:43 PM
Subject: Re: Getting a file to excel


Be careful with attempting to put data into an excel spreadsheet.
One of the problems we have (and if anyone can post an answer to this, we
would be very grateful), is that a credit card number is held in a 19 digit
numeric field. Once this field is placed into an excel spreadsheet, excel
will only display the first 15 numbers, 0 filling the rest - NO MATTER what
the rest is.
I know this is a problem with excel, but, like I said,  if anyone has an
answer....


Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx