Unix import of a DOS spreadsheet...
Mike Schwartz
mschw at athenet.net
Fri Sep 3 17:45:43 PDT 2010
filePro 5.0.15K7R4 running on SUSE Linux 2.6.31
import ascii xcsv=(fn) r=\n f=, o=" c="
Sample text line from the CSV file:
"946","Payment","6/10/2008","73040",,"Sampson","06/10/08","A/R","",1136.80
(Note missing double-quote delimiters on last data field.)
I was trying to import a spreadsheet that has lines that terminate in
0D 0A hex. The Unix import function was reading in all the characters until
it got to the last 0A on the line, so the 0D was ending up in the last field
and messing up the screen drawing.
I tried to rewrite the import as:
import ascii xcsv=(fn) r=13&10 f=, o=" c="
However, I get a syntax error. Is this still a supported way to set the
end-of-record delimiter in 5.0.15?
Since /r designates the single character 0A in Unix, how else can I
designate the 0A/0D combination on a Unix import line?
Thanks!
Mike Schwartz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20100903/fb0f6f59/attachment.html
More information about the Filepro-list
mailing list