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
