Re: AS400 to EXCEL

[MEovino@xxxxxxxxxxxxxxxxx]

Also not an option my customers wanted.  They wanted Excel.  No ifs, ands
or buts, and definitely no conversion wizards.

Mike E.



                                                                                
                                     
                    "Richard B Baird"                                           
                                     
                    <rbaird@xxxxxxxxxxxx       To:     RPG programming on the 
AS400 / iSeries                        
                    lting.com>                  <rpg400-l@xxxxxxxxxxxx>         
                                     
                    Sent by:                   cc:                              
                                     
                    rpg400-l-bounces@xxx       Subject:     Re: AS400 to EXCEL  
                                     
                    range.com                                                   
                                     
                                                                                
                                     
                                                                                
                                     
                    05/20/2003 02:07 PM                                         
                                     
                    Please respond to                                           
                                     
                    RPG programming on                                          
                                     
                    the AS400 / iSeries                                         
                                     
                                                                                
                                     
                                                                                
                                     





I just found out a way this morning to not lose your leading zeros.  It
takes a little more work, but it does work.

change the file extention (or create it that way) to .txt and open the file
from inside excel.  it walks you through the import wizard - change to
'delimited', change the delimeter to ',' and on the next screen, change the
data type of the numbers from 'general' to 'text'.

this will preserve your leading zeros.  not optimal, but doable.

Rick
--------original message---------
Booth,

>Is this also true if the CSV fields are all enclosed in quotes?  Not
>apostrophes but quotation marks.

In Excel, it still considers it a numeric value and drops the leading zeros
despite the presence of the quotation marks.  Silly, but true.

>"John Smith","001234"

Not in Excel it doesn't.  The second cell will be right-adjusted and the
value
displayed will be simply 1234.  Even applying a cell format of "text" at
that
point will leave it as 1234 (albeit now left-justified).  So the leading
zeros
are lost during the file open / import process.

Doug


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.