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
