Re: Changing layout of .csv files

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

Angela, I am confused by your message.  You say you are being told that the 
"data does not come in all on one line for a record".  What exactly does this 
mean?  Could you attach a couple of lines of your final record and then tell us 
what's wrong with it?

Joe

---------- Original Message ----------------------------------
From: Angela Wawrzaszek <wawrzaszeka@AUSTEEL.com>
Date: Thu, 8 Feb 2001 15:06:53 -0500 

>I have converted an AS/400 file to a .csv two different ways.
> 
>1.  CPYTOIMPF - I  specify no string delimiters and to use commas as field
>delimiters.  I use carraige return for the record delimeter.   The company I
>sent this to says it will not convert into their system,  that the data does
>not come in all on one line for each record,  although he says they allow
>for 132 characters, and each record is only 51 positions.
> 
>2.  Client Access Data Transfer -  The file from here has double quotes
>around each of the character fields but does not line wrap.  He cannot
>handle the double quotes either.
> 
>Is there a way to change either one of these to have a .csv file with no
>double quotes and one record per line?  I do not know what conversion he is
>putting it through,  he just says it converts a csv to a database for his
>unix file.
> 
>HELP!!!
>
>Angie Wawrzaszek 
>M.I.S. Department 

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---