Simon - thanks - but this used to work on 3.7.7.1 (I believe was the last version I downloaded and unfortunately replaced with the latest...)
How, then, do you import character columns that contain commas (like addresses) from a .csv which uses commas as a delimiter? Thanks ! On Mon, Jan 16, 2012 at 7:43 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 16 Jan 2012, at 3:34pm, Udi Karni wrote: > > > "COL1","COL2" > > "XXXX","YYYY" > > "XX,X","YYYY" > > Sorry, but the shell tool doesn't understand quotes in csv files. > > Simon. > _______________________________________________ > 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
