On 15 February 2010 15:58, Simon Slavin wrote: > > C:\sqlite>type test.csv > > "test 1" > > "test ""2""" > > It's doubling quotes up because they're inside quoted text strings.
I think that file is good and valid csv. But the .import command isn't doing what you're expecting. In shell.c, around line 2559, the shell does a simple splitting of the line by a separator (in this case ',') but isn't actually following any rules for splitting and de-escaping csv data. Not doing the ".mode csv" before the ".import" makes things better but doesn't fix it. Do you need to read the csv data back in to a sqlite database? If not, then the file you've got should be ok. If you do then I think you will need to either alter shell.c or create your own program to read a csv file and insert it. Regards, Paul. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
