RE: converting files and many views -- MIDRANGE-L

There is no comma delimited file standard--it's just custom and personal
preference.  I think the quoted string is more common than the strings
without quotes.  

I don't think Client Access file transfer allows you to eliminate the quotes
on character fields, but CPYTOIMPF does with the STRDLM parameter. It allows
you to specify anything you want, including *NONE as the string delimiter.
(Different parm from the field delimiter)  

I don't understand the problem with lines wrapping with CPYTOIMPF.  That
would imply that there are extraneous carriage returns, line feeds, or CRLF
pairs in the lines that are wrapping.  I've converted a lot of files with
reasonably large record lengths using CPYTOIPMF without seeing this problem.
I just sent out a test file with a 369 byte record length this morning.  

Once you get past the code page problem (see recent thread) CPYTOIMPF is a
pretty good utility.  It offers you a lot of flexibility in the type of text
file and also allows you to specify date and number format.  


-----Original Message-----
From: Angela Wawrzaszek [mailto:wawrzaszeka@AUSTEEL.com]
Sent: Monday, March 12, 2001 8:44 AM
To: Midrange Mail List (E-mail)
Subject: converting files and many views


I am curious as to why transferring data is not standard 

ie.  I take a as/400 file  and transfer it in the following ways and each
one gives me a different file.  

1.  Transfer into excel,  then do saveas to .csv     This produces the
desired file.  No quotes on the char fields and no line wrapping.  However I
can not seem to find a way to automate this.

2.  AS/400 data transfer  (.dtf file)  and then do as/400 command   cpy
obj(myfile.csv)  toobj(newfile.csv)  fromcodpag(*pcascii)  dtafmt(*text)
This produces a csv file but it has quotes around the char fields which I do
not want.

3.  AS/400 data transfer (.dtf file)   and then do with strpco  I copy the
csv file to the desired name.    This also produces a csv file with quotes
in the char fields.  

4.CPYTOIMPF  -  creates csv file no quotes however it line wraps.

5.  FTP through a .bat file -   creates gibberish.


Is there a way to NOT put quotes on the char fields using CA dta transfer?
This seems to be the only way the file gets created normally with out having
to manually bring it in to excel and do a saveas.

I have been going through the archives and it seems everyone is using
cpytoimpf  and the cpy obj commands.  However when I try these I am still
not getting the file I desire.

Thanks!!!


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