from my experience, sed will read line by line, which is not good for the CSV file.(one field can be on multiple lines).
why sqlite is not enhanced to handle fully the csv file format? Cheers, Sylvain On Fri, Mar 6, 2009 at 11:33 PM, John Machin <sjmac...@lexicon.net> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
