On 22 Sep 2009, at 10:49pm, Simon Davies wrote: > 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
Fast hack if you need to do this only once: Use a text editor on the file and change all occurrences of (including the quotes) "," to "|" then set .separator to the single character | before you import the file. If you're going to need to import such files frequently, you might need to write some code to do the import properly. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
