On 8 Sep 2009, at 9:48pm, Robert Citek wrote: > Just a guess, but you may be running into issues with the end-of-line > character as they are different under linux (\n), Mac (\r), and > Windows/DOS (\r\n). > > Linux has a tool to convert Windows/DOS end-of-lines to linux-style > called dos2unix. There may be one for Mac, too, but I'm not sure. If > not, you could use tr. For example: > > $ < mac.csv tr '\r' '\n' > unix.csv > > Good luck and let us know how things go.
The Mac OS is just a pretty GUI built on the top of Unix. Therefore 'tr' is present on the Mac. Also you can do 'hexdump -C filename' to see exactly what characters a file is using for returns. Or there's a good GUI application called '0xED' which will let you do both jobs. What we're missing is the information on which characters the sqlite3 tool will considers to be a line-end. I'm sure someone could read the source code and find out. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
