Re: CSV file problems

[Pat Barber <mboceanside@xxxxxxx>]

Well, after some major screwing around with various methods,
sheri sent me a link to a open source program called crtcsvf.

I downloaded that and it creates the file just fine.

Using Sheri's suggestion, I used 37 as the ccsid and did the copy
to the IFS and that created a file with a ccsid 437.  I then opened
that file directly with Excel and it opened just fine. I also tried it
with Notepad and it opens it with individual records.

This entire ccsid thing is a mystery to me. I thought that was related
to different language versions of the OS.

I just don't understand the cpytoimpf and it's results.

I just ran a test using this command:

CPYTOIMPF FROMFILE(TCS/SNPREM) TOSTMF('/home/patrick/snpremtst.csv') 
RCDDLM(*CRLF)  

That creates a file with ccsid of 37.

That's readable using wrklnk but is complete garbage opened in WordPad.

but if I do this:

CPYTOIMPF FROMFILE(TCS/SNPREM) TOSTMF('/home/patrick/snprem437.csv') 
MBROPT(*REPLACE) FROMCCSID(37) STMFCODPAG(*PCASCII) RCDDLM(*CRLF) 

It is readable in WordPad and Excel and the ccsid in the IFS is 1252 ???

Is there a correct combination to use if the file is to be send to 
another site ???        

                                                          
rob@xxxxxxxxx wrote:
> You're right, you should be seeing individual records.
> Try it in WordPad.
>
> If it looks like individual records in WordPad but not in Notepad that 
> means you only half got the CRLF right.  If it still looks like one big 
> stream in WordPad that means you totally blew the CRLF.
>
>
> Rob Berendt
>