On 15 Feb 2010, at 7:23pm, Phil Hibbs wrote: > Simon Slavin: >> The command-line tool is correct as far as it goes in producing CSV >> files: if you use quotes around text fields, it is correct to double quotes >> inside those fields. Take a look at the CSVs you're trying to import. >> Are the text fields delimited by quotes ? If quotes appear in the field, >> are they doubled ? > > In this case, the csv file that I'm trying to import was created by > SQLite. And yes, fields containing quotes or commas are quoted with > the internal quotes doubled up. It's SQLite3's import that does not > correctly handle the doubled-up quotes that it correctly wrote out.
So the command-line tool cannot correctly read the CSV files it output itself ? Okay, that's messed up. Something should be done. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users