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
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Excel not reading char fields correctly
Collapse
X
-
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