RE: Changing layout of .csv files

["Draper, Dale" <dale.draper@xxxxxxxxxxxx>]

It sure sounds like the problem could be on his end. But you might play a
bit with the CPYTOIMPF. I had the same problem once. Have your tried a plain
TXT file? Sometimes those translate better. 
 

> -----Original Message-----
> From: Angela Wawrzaszek [SMTP:wawrzaszeka@AUSTEEL.com]
> Sent: Thursday, February 08, 2001 12:58 PM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      RE: Changing layout of .csv files
> 
> Thats just it,  I see the file fine,  when he pulls it in through his
> program it does not come through okay.  I just did a download of a file in
> excel using MSQuery and then saved that spreadsheet as a .csv ignoring the
> conversion warning messages.  This file he could read!!??
> 
> All of the file look fine when viewing in excel but some program of his
> "reads" each one differently
> 
> 
> File nau020801  was created with CPYTOIMPF
> 
> File nau020901  was created with Client Access transfer
> 
> File nau021001  was created with msquery into .xls then re-saved as a .csv
> 
> ???????? 
> Angie Wawrzaszek
> M.I.S. Department
> 
> 
> -----Original Message-----
> From: Joe Pluta [mailto:joepluta@plutabrothers.com]
> Sent: Thursday, February 08, 2001 3:24 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Changing layout of .csv files
> 
> 
> 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
> +---
>  << File: NAU020801.CSV >>  << File: NAU020901.CSV >>  << File:
> NAU021101.CSV >> 
+---
| 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
+---