2009/9/22 Pavel Ivanov <paiva...@gmail.com>: >> 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.
You can use .separator to specify pipe (or any other character of choice) as the field separator for .import Your separator needs to be a character that does not appear anywhere in your data > > > Pavel > Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users