On 24 Sep 2009, at 8:37pm, C. Mundi wrote: > Happily, sqlite has a very nice .output mode for CSV. It correctly > double-quotes fields when they contain a space or a comma, and it > correctly > 'escapes' double-quote literals as "". Great! I need to go the > other way. > > I don't see an inverse .import mode in sqlite to handle the completely > general CSV syntax. As anyone who has ever tried knows, parsing > compliant > CSV is a lot harder than writing compliant CSV.
Sorry, but you didn't miss anything, no such facility exists. The .import command does not handle quoted fields correctly, as has recently been stated on this list. Some third-party tools do it fine but if you want to import your particular file you'll have to tweak your file so that whatever you're using as a separator never appears inside a field. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users