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 leading zeros are ignored). found on a Google web site... 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. QUESTION: How can I get CPYTOIMPF to put an =" in frount of my test fields? Thank you, GuyHenza@hotmail.com
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
CPYTOIMPF
Collapse
X
Comment