On 7/03/2009 6:16 AM, Rich Shepard wrote: > On Fri, 6 Mar 2009, Hans-Martin wrote: > >> It seems that there is no way to get rid of the embedded CR/LF without parse >> the complete output. > > Use sed. That's what it's for.
Has anyone considered that getting rid of the embedded CR/LF is destroying information? Has anyone considered the possibility that SQLite .import could be made to support the CSV format? Alternative: read the CSV file and update the SQLite3 database using a scripting language with the appropriate capabilities (Python definitely, Perl surely, others ...) Cheers, John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users