On 16 Jan 2012, at 4:49pm, Udi Karni wrote: > Hmmmmm.... so there is no way to specify (borrowing syntax from other DBs) > something like - "DELIMITED BY ',' ENCLOSED BY ' " ' ?
To import fields which contain commas use a delimiter other than a comma to separate your fields and preceed your .import command with a .separator command. Or write your own importer and use that instead of the shell tool. The .import command isn't SQLite. It has nothing to do with the SQL API, it's just a feature built into the command-line tool. It's very primitive and doesn't deal much of anything besides very simple delimited fields with one record per line of text. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
