AS400 data to .csv problem in Excel

["Jim Franz" <franz400@xxxxxxxxxxxx>]

I know many of you have done as400 to Excel using .csv. I'm having a very strange

problem and could use some help.

 

Building .csv files in IFS for web users. Users make request thru cgi, clp builds stmf

to set code page, then cpytoimpf to create delimited file

 CPYTOIMPF  FROMFILE(&CUST6/WWRTN *FIRST) TOSTMF(&URLW1) +     
  MBROPT(*REPLACE) RCDDLM(*CRLF) DTAFMT(*DLM) STRDLM('"') FLDDLM(',')            
 CPYTOIMPF  FROMFILE(&CUST6/WWRCPY *FIRST) TOSTMF(&URLC1) +    
  MBROPT(*REPLACE) RCDDLM(*CRLF) DTAFMT(*DLM) STRDLM('"') FLDDLM(',')    

 

File looks ok in wordpad, except I expected delimiter at end of data, but these files

only have delimiter at end of each field.

When Excel 2000 displays data, one field, 20 byte number has changed from

,"71010412344005315256", to 7.10104E+19. In fact every number in that column

resulted in the same strange number. (the 20 digit number is certified mail numbers

and the first 11 bytes are always the same, and MUST be included).

Some other colums, with values like CC, OW, 01, only the 01 is right justified, zero

suppressed. In both cases the cell format is "general" which I think is messing it up,

but see no way to set to "text" when building this.

 

Before we go too far... this process allows any web user to dynamically select data

to download to their pc. The .csv is the standard for this industry (they can't spell

XML or anything other than "Excel" or "spreadsheet". Some are reading the files

in FoxPro. File name is unique every time. Client Access is not an option.

FTP is not. Needs to run, look, feel like any other website with no special plugins.

Don't know if this is a "feature" of Excel 2000, but that's all we have on inhouse

desktops to test with. Am at V4R4, fairly recent ptfs. On V4R5 in a few weeks.

Any help appreciated.

jim