Import/export with leading zero

[Richard Kreiss]

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