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: sqlite-users-boun...@sqlite.org 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 <clem...@ladisch.de> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
