Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1758
  • Last Modified:

Transfer iSeries file to .csv file without quotation marks

Hi,

I am transferring an iSeries file to a .csv file on my PC.
At the moment it puts quotation marks around each field in the .csv file

e.g.
"1","","","","084069685559690","","110315","110315",""

Is it possible to get it to transfer the file without the quotation marks

e.g.
1,,,,084069685559690,,110315,110315,


0
carlaohare
Asked:
carlaohare
  • 2
  • 2
1 Solution
 
Gary PattersonVP Technology / Senior Consultant Commented:
How are you performing the transfer?  What tool?

- Gary Patterson
0
 
carlaohareAuthor Commented:
Hi Gary,

I'm using client access
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
Client Access File Transfer Function doesn't give you any control over the CSV format.  Options:

Download as CSV using CA-FTF tool, and use a PC-based editor (I like NotePad++) to remove all of the double-quote characters.  As long as your data doesn't contain embedded quotes, this works OK.

Download as tab-delimited and use PC-Based editor to replace tabs with commas.

Use CPYTOIMPF commnd to create a delimited file without quotes, and then download the stream file created using FTP, Navigator, NetServer, etc:
CPYTOIMPF FROMFILE(GARYP1/TEST1)
          TOSTMF(test1.csv)    
          STMFCODPAG(*PCASCII)  
          RCDDLM(*CRLF)        
          STRDLM(*NONE)

- Gary Patterson

         

0
 
carlaohareAuthor Commented:
Thanks Gary,

I'll give that a go.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now