CPYFRMIMP inserting quotation marks

5 pts.
Tags:
AS400 iseries
CPYFRMIMPF
iseries v5r4
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
ASKED: March 16, 2012  3:33 PM
UPDATED: March 30, 2012  2:40 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Jotta
    Hi You use the flddlm parameter ot try to copy as fixed record Jotta
    45 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following