Am 16.01.2012 17:57, schrieb Richard Hipp:
Changes to the command-line shell so that it understands quoted fields have
now been checked in.
thanks - what about a possibility to recognize special characters (i.e.
\NULL) or delimiter""delimiter or delimiterdelimiter as NULL during the
import? I'm only asking because you started to introduce this luxury
feature ;-)
greetings from a grateful user
Oliver
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
