Actually, I found the "correct" solution for the version of SQLite3 bundled with Linux Mint13 KDE.
2in|"2""" It isn't documented anywhere, but, you have to BOTH quote the string AND double up the quotes inside of it. Something like this should be documented in the FAQ or on the home page. I found it to be a very common question with a lot of worthless answers, at least worthless given the current state of the tools, perhaps they were valid at one point. Roland ________________________________________ From: [email protected] on behalf of Petite Abeille Sent: Tuesday, June 18, 2013 4:19 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] escape quote for csv import On Jun 18, 2013, at 10:02 PM, Clemens Ladisch <[email protected]> wrote: > (There is no official CSV standard, and there is no widely supported > escaping mechanism.) Perhaps. But that's not an excuse to ignore the de facto convention: Common Format and MIME Type for Comma-Separated Values (CSV) Files http://tools.ietf.org/html/rfc4180 Plus, that tired argument about "no official csv standard" is a bit self -fulfilling. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
