Am Freitag, 6. März 2009 23:33:33 schrieb John Machin: > 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?
That's not true. It's not about to delete the CR/LF, it's about not to use the same character in a value as it's used in the csv-format. If you change all embedded CR/LF into \n for example, you get all data through. But what if someone uses \n in a text? So \ in a text have to be \\ so that the text is \\n and not \n anymore. > > 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 Hans-Martin > > _______________________________________________ > 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
