Import/export with leading zero

[Bruce Easton]

Richard Kreiss wrote Monday, February 11, 2008 1:24 PM:
> To: filepro-list at lists.celestial.com
> Subject: Import/export with leading zero
> 
> 
> Using the following for export of a csv file with 2 fields having 
> leading zeros.  On import to Excel, the zeros are dropped.
> 
> 12  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   
> -   -   -
>        ◄ If:
>        Then: export ASCII com=c:\temp\secret.csv r=\n f=, -x
> 24  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   
> -   -   -
>       ◄ If: 'item #
>       Then: com(2)="\""{item_number{"\""
> 
> When viewed with a text editor, the field is quoted "03001" but 
> when opened, Excel drops the leading zero.
> 
> Any suggestions as to what I am doing wrong?
> 
> 
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
>   
> 

Richard - format the Excel column for that field to type text (and 
alignment right if desired) prior to opening your file to load 
into the spreadsheet.

Bruce

Bruce Easton
STN, Inc.