Re: AS400 data to .csv problem in Excel

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

7.10104E+19 is the number 71010412344005315256 in scientific notation.
You want to see this cell as a text string instead of a number.
In Excel, click on the column that number is in to select it, then 
right click, select Format Cells.  click on "Text" then okay.  After
adjusting the width of the cell you should see the whole value correctly.

Incidentally, to understand the number 7.10104E+19, take the root number,
7.10104 then move the decimal place 19 places to the right.  This produces
71010400000000000000.  As you can see, you loose precision when viewing
numbers in scientific notation, but you can represent extremely large numbers
in a short amount of space this way.

Regards,

Jim Langston

Me transmitte sursum, Caledoni!

Jim Franz wrote:
> 
> 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
+---
| This is the WEB400 Mailing List!
| To submit a new message, send your mail to WEB400@midrange.com.
| To subscribe to this list send email to WEB400-SUB@midrange.com.
| To unsubscribe from this list send email to WEB400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---