Re: CPYTOIMPF and CSV Format

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Ken,

CPYTOIMPF only allow trimming of leading spaces. There is a special parameter 
for that. So, Scott's suggestion to extend the command is not (that) difficult.

Perhaps in the next PTF's for various Os levels ? (They did that for parameter 
value *PCASCII).

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 13-8-03 at 16:10 Ken.Slaugh@xxxxxxxxxx wrote:

>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.