Not an option, but thanks for the suggestion. ________________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Clemens Ladisch Sent: Tuesday, June 18, 2013 4:02 PM To: sqlite-users@sqlite.org 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 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