On Fri, Oct 14, 2011 at 7:37 AM, Simon Davies
<simon.james.dav...@gmail.com>wrote:
> On 14 October 2011 15:17, James Hartley <jjhart...@gmail.com> wrote:
> > When attempting to import CSV data, the shell balks...
>
> and look at what the separator is set to in the .show output...
>
I have got to stop working until 3:00am. Your suggestion points to what I
did not verify. The original CSV is much richer with double quoting some
values. The following shows that setting the separator as I was within the
shell does not do what I was expecting:
$ sqlite3 -separator '",'
SQLite version 3.7.5
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .show
echo: off
explain: off
headers: off
mode: list
nullvalue: ""
output: stdout
separator: "","
stats: off
width:
sqlite> .q
$
Thank you for your reply.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
