The fact that there's no "official CSV standard" doesn't mean that there isn't
"common practice" that SQLite should support (but I can't say that I know that
it does; it should be easy to change if it doesn't).
The "common practice" is to double each embedded double-quote.
"abc","the char in parens ("") is doublequote","def"
-----Original Message-----
Date: Tue, 18 Jun 2013 22:02:31 +0200
From: Clemens Ladisch <clem...@ladisch.de>
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] escape quote for csv import
Message-ID: <51c0bcd7.4050...@ladisch.de>
Content-Type: text/plain; charset=ISO-8859-1
Roland Hughes wrote:
> How does one escape a in a CSV file so it will correctly import?
The sqlite3 tool allows to configure the separator, but the quote
character for delimiting fields is hardcoded.
(There is no official CSV standard, and there is no widely supported
escaping mechanism.)
> I can only massage the CSV
Convert it into properly formatted SQL INSERT statements.
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
