Re: [sqlite] .import with .separator and quoted strings

PROTECTED] On Behalf Of Griggs, Donald Sent: Thursday, August 21, 2008 5:38 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] .import with .separator and quoted strings Hi Ron, I've encountered that as well. You're using the sqlite3 commandline interface program, I'm sure. I

Re: [sqlite] .import with .separator and quoted strings

ere a mode that causes the .import command to honor quoted entries? RW sqlite>select level from sqlGuruOMeter where name="Ron Wilson"; 2 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Ron P Sent: Tuesday, August 19, 2008 4:49 PM T

Re: [sqlite] .import with .separator and quoted strings

auses the .import command to honor quoted entries? RW sqlite>select level from sqlGuruOMeter where name="Ron Wilson"; 2 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Ron P Sent: Tuesday, August 19, 2008 4:49 PM To: sqlite-users@sqlite.o

[sqlite] .import with .separator and quoted strings

I'm trying to import a table using the command line tool. sqlite> .separator , sqlite> .import export.csv library export.csv line 1: expected 53 columns of data but found 77 sqlite> .mode csv sqlite> .import export.csv library export.csv line 1: expected 53 columns of data but found 77