CPYFRMIMP inserting quotation marks
I am trying to use CPYFRMIMPF to copy a tab delimited file to a physical file. The problem I have is that the file has commas (,) in the text and CPYFRMIMPF automatically inserts quotation marks around the text whenever there is a comma in the field.
For example, if my tab delimited file has 2 fields Emp#, Empname and I have a record 99999 Smith, John when it get to the AS/400 it appears as "Smith, John"
I know it is the comma messing it up. How can I get it to ignore the comma?
Software/Hardware used:
Iseries, V5R4
For example, if my tab delimited file has 2 fields Emp#, Empname and I have a record 99999 Smith, John when it get to the AS/400 it appears as "Smith, John"
I know it is the comma messing it up. How can I get it to ignore the comma?
Software/Hardware used:
Iseries, V5R4
ASKED:
March 16, 2012 3:33 PM
UPDATED:
March 30, 2012 2:40 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
How can I get it to ignore the comma?
Without seeing what command you’re already trying to run, it’s hard to guess how you should change it.
If I try to do the same thing as you describe, it doesn’t happen to me. Fields with embedded commas come across without getting quotes added.
Tom
Hi
You use the flddlm parameter ot try to copy as fixed record
Jotta