> If I understand correctly, I can remove all quotes as long as the only > commas delineate columns. Or, I can use the pipe as a separator and remove > all quotes, too. Correct?
AFAIK, you can do only the first - remove all quotes and make sure that no commas met in field values. Pavel On Tue, Sep 22, 2009 at 5:40 PM, Rich Shepard <rshep...@appl-ecosys.com> wrote: > On Tue, 22 Sep 2009, Pavel Ivanov wrote: > >> No, the problem is that sqlite3 command line utility doesn't parse quotes >> in csv files. It gets line, splits it using comma as delimiter, >> disregarding any quotes and then inserts resulting strings into database. >> So you'll have to use something else for importing your database, maybe >> write your own importer. > > Pavel, > > If I understand correctly, I can remove all quotes as long as the only > commas delineate columns. Or, I can use the pipe as a separator and remove > all quotes, too. Correct? > > I've not before dealt with importing an externally-created .csv so this is > new territory for me. > > Thanks, > > Rich > > _______________________________________________ > 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
