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