Changes to the command-line shell so that it understands quoted fields have now been checked in.
On Mon, Jan 16, 2012 at 11:49 AM, Udi Karni <uka...@gmail.com> wrote: > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
