Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

CPYTOIMPF

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

  • CPYTOIMPF

    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

  • #2
    CPYTOIMPF

    I think that you will have to place the equal sign in front of the numeric field that you have defined as character. That is what I would do.

    Comment

    Working...
    X