Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1718
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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