I add the Carriage returns (hex-13), not LF's.
When I convert these stuff, I use a freeware/shareware program called Unix2DOS.
You could find a bunch by searching
http://www.shareware.com (or even google).
UNIX lines end with hex-10.
DOS/Windows lines end with hex-13, hex-10.
Dave Peterson wrote:
Two questions:
#1. Does each line of your CSV file end with a carriage return/line feed?
(If I get a file FTPed from a UNIX box, I have to add those linefeeds.)
#2. Does the delimiter in your CSV file match the character under:
Windows start button|settings|control panel|regional settings applet|
Number Tab|list character?
hbarniv wrote:
I use Excel XP and when try to open a .csv file, get a message:"File not
loaded completely". I click OK and get one long row of data. Anyone knows
why?
ALso, when importing the .csv file to Excel, the columns get shifted and in
one field I get | instead of comma. Any ideas?
Thanks
--
Dave Peterson
--
Dave Peterson