|
V5R2... I have found other posts that state that the spaces are not removable with CPYTOIMPF. I also found www.dbg400.com that offers a CRTCSVDTA command and I'm in the process of installing it. Ken Slaugh (707) 795-1512 x118 Chouinard & Myhre, Inc. CA/400 Certified Specialist iSeries Network/MSE Administrator http://www.cm-inc.com/ "Art Tostaine, Jr." <artjr@xxxxxxxxxxx> To: "'Midrange Systems Technical Discussion'" Sent by: <midrange-l@xxxxxxxxxxxx> midrange-l-bounces@x cc: idrange.com Subject: RE: CPYTOIMPF and CSV Format 08/13/2003 07:14 PM Please respond to Midrange Systems Technical Discussion We're at V5R1, never seen that before. Are on V4Rx? Maybe a PTF? Art Tostaine, Jr. CCA, Inc. Jackson, NJ 08527 -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ken.Slaugh@xxxxxxxxxx Sent: Wednesday, August 13, 2003 7:11 PM To: Midrange Systems Technical Discussion Subject: CPYTOIMPF and CSV Format Anyone know how to get the CPYTOIMPF command to output CSV? Here's the command I ran... ===> CPYTOIMPF FROMFILE(DSPERS SQPERS) TOSTMF('/home/cmi/tulare/SQPERS') STMFCODPAG(*STDASCII) RCDDLM(*CRLF) This is the first record in the file. " ",8832 ,"BAN ","TERRA ","INC "," ",0 ,0 ," "," "," "," "," "," "," "," "," "," "," "," "," ",0 ,0 ," "," "," "," "," "," ",0 ,0 ,0 ," "," ",0 ," "," ",0 ,0 ,.00 ," "," "," "," "," ",0 ,0 ," "," "," "," ",.00 ," ",0 ,0 ,0 ,0 ,0 ,"CLW "," ",19 ,980508 ," "," "," "," "," "," "," "," "," ",0 As you can see the record contains LOTS OF SPACES. Can they be eliminated somehow to results in: "",8832,"BAN","TERRA","INC","",0,0,"","","","","","","","","","","",""," ",0,0,"","","","","","",0,0,0,"","",0,"","",0,0,.00,"","","","","",0,0," ","","","",.00,"",0,0,0,0,0,"CLW","",19,980508,"","","","","","","",""," ",0 I have tried STMFCODPAG(*PCASCII) and STMFCODPAG(1252) as well without success. TIA, Ken Slaugh (707) 795-1512 x118 Chouinard & Myhre, Inc. CA/400 Certified Specialist iSeries Network/MSE Administrator http://www.cm-inc.com/ _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
