csv format files
Fairlight
fairlite at fairlite.com
Thu Feb 12 15:20:14 PST 2009
Confusious (Bruce Easton) say:
> 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.)
DOS files used to end ^Z...it marked eof. xtod is prolly emulating this
format.
m->
--
"I'm not subtle. I'm not pretty, and I'll piss off a lot of people along
the way. But I'll get the job done" --Captain Matthew Gideon, "Crusade"
More information about the Filepro-list
mailing list