Oliver - thanks ! Hmmmmm.... so there is no way to specify (borrowing syntax from other DBs) something like - "DELIMITED BY ',' ENCLOSED BY ' " ' ?
On Mon, Jan 16, 2012 at 8:32 AM, Oliver Peters <oliver....@web.de> wrote: > Am 16.01.2012 17:10, schrieb Udi Karni: > > 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...) >> > > > afaik this never worked with the original CLI (might be that you have used > a fork that can do this) > > I see 3 solutions: > > if you can influence the delimiter take a reliable delimiter (a string > you're not using in your file - maybe a |) and export without " as markers > for text columns > > if cant't influence the look of the source find and don't mind to do it > manually you can import into a spreadsheet program and use a reliable > delimiter without using " > > if you like scripting you can create a little program with your favorite > language > > greetings > Oliver > > > >> 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<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
