Thanks Dr. Hipp ! (1) Wow - what fast turnaround in the share-ware world !!!
(2) I am new to share-ware. I don't compile my own code. How long between "checked in" and "included in the shell-for-windows on the download page" ? On Mon, Jan 16, 2012 at 8:57 AM, Richard Hipp <d...@sqlite.org> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users