csv format files

Bruce Easton bruce at stn.com
Thu Feb 12 15:08:03 PST 2009


I'm working with a filepro-based program that produces csv files on Unix.
The file will ultimately gets used by someone's SQL Windows-based app
(unknown).  On Unix, when I use the xtod command, the file I wind up with
has a Ctrl-Z at the end (all by itself on the last line).  My Excel opens
the resulting file up fine, but the client's SQL issues an error (??).

I do notice that if I save an Excel spreadsheet in MS-DOS csv format,
transfer binary to Unix and then look at it - it does not have the Ctrl-Z at
the end, so I guess my question is - is the Ctrl-Z normal for the xtod
program or do I have a bad xtod?

(I'm assuming that in any case I will be able to tr or sed out the Ctrl-Z if
need be.)

Bruce

Bruce Easton
STN, Inc.



More information about the Filepro-list mailing list