Not an option, but thanks for the suggestion. ________________________________________ From: [email protected] on behalf of Clemens Ladisch Sent: Tuesday, June 18, 2013 4:02 PM To: [email protected] Subject: Re: [sqlite] escape quote for csv import
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 [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
