Re: [sqlite] importing CSV data on command-line?

2011-10-15 Thread Sylvain Pointeau
> > 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: > > I made one that I

Re: [sqlite] importing CSV data on command-line?

2011-10-14 Thread James Hartley
On Fri, Oct 14, 2011 at 7:37 AM, Simon Davies wrote: > On 14 October 2011 15:17, James Hartley 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

Re: [sqlite] importing CSV data on command-line?

2011-10-14 Thread Simon Davies
On 14 October 2011 15:17, James Hartley wrote: > When attempting to import CSV data, the shell balks at the command-line but > is otherwise fine when all is done interactively.  I suspect user error, but > I just don't see it. Any insight shared would be greatly appreciated.

[sqlite] importing CSV data on command-line?

2011-10-14 Thread James Hartley
When attempting to import CSV data, the shell balks at the command-line but is otherwise fine when all is done interactively. I suspect user error, but I just don't see it. Any insight shared would be greatly appreciated. Thanks. $ ls create_table.sql src.csv $ cat create_table.sql src.csv