RE: Comma-delimited help

["Cletus" <cletusr@xxxxxxxxxx>]

Bring it down to a file, import it into Excel or 123, and then pump it back
to the 400. 

-----Original Message-----
From: midrange-l-bounces+cletusr=ssibtr.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+cletusr=ssibtr.com@xxxxxxxxxxxx] On Behalf Of
Andy Draus
Sent: Friday, February 25, 2005 3:41 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Comma-delimited help

Anyone able to offer a little download help?

I'm trying to download (via ftp) from the 400 to a comma-delimited file (to
a T&A system), using the following command:

CPYTOIMPF FROMFILE(HS#LIBR/PPPTADN) TOFILE(HS#LIBR/PPPTADNCSV)

The results are like so:

"8732","A","JOHNSON             ","LINDA               ","NODIFF     
","9066","    "
"6289","A","SMITH               ","MARIANNE            ","40/40      
","9596","    "

but I was expecting something like this:

"8732","A","JOHNSON","LINDA","NODIFF","9066","    "
"6289","A","SMITH","MARIANNE","40/40","9596",""

.... the extra blanks within each set of quotes is killing the import. 
Any clues as to what I should be doing differently would be greatly
appreciated!


Andy




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