Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Excel not reading char fields correctly

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel not reading char fields correctly

    I have used the CPYTOIMPF to copy data from an AS400 PF file to a IFS file in Excel (csv file). But I am having a problem, I have fields defined in the AS/400 as CHAR like this: "000717" what I will see in Excel is 717 (the three zeros are ignored). These are item numbers and the leading zeros are significant. Is there any solution to this problem? Thank you, GuyHenza@hotmail.com

  • #2
    Excel not reading char fields correctly

    If you have a character variable that is inherently numeric and contains leading zeroes, then the leading zeroes are lost when EXCEL reads the CSV file (eg we have bank account numbers like 00000000756477438 which are text throughout every system in the bank). To not lose these, the CSV file must contain "=" before the quoted string containing the variable value.

    Comment

    Working...
    X