Am 16.01.2012 17:49, schrieb Udi Karni:
Oliver - thanks !
Hmmmmm.... so there is no way to specify (borrowing syntax from other
DBs) something like - "DELIMITED BY ',' ENCLOSED BY ' " ' ?
yes, no way :-)
if you want to discover the possibilities of the CLI type .h (after
having started with sqlite3)
Oliver
On Mon, Jan 16, 2012 at 8:32 AM, Oliver Peters <oliver....@web.de
<mailto: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 <mailto: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 <mailto: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
