It turns out that CRLF may have something to do with it.
I can get rid of the errors, either:
1. if I replace "" with nothing,
OR
2. if I save the file as Linux style (LF only).
-----Original Message-----
From: [email protected]
Sent: Wednesday, August 28, 2013 4:16 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] v3.8 .import misbehaves
OK, now copy the data line several times, and you'll see there are errors
for several lines, unrelated to the final CRLF (which I removed this next
sample).
-- data --
"Year","Debt","GDP1","GDP2","RGDP","dRGDP","Infl","debtgdp"
"1833","","49.3275923134","","118.3483703666","","",""
"1833","","49.3275923134","","118.3483703666","","",""
"1833","","49.3275923134","","118.3483703666","","",""
"1833","","49.3275923134","","118.3483703666","","",""
"1833","","49.3275923134","","118.3483703666","","",""
"1833","","49.3275923134","","118.3483703666","","",""
-----------
C:\temp>sqlite3.exe
SQLite version 3.8.0 2013-08-26 04:50:08
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .sep ,
sqlite> .import data tab
data:3: unescaped " character
data:4: unescaped " character
data:5: unescaped " character
data:6: unescaped " character
data:7: unescaped " character
data:2: expected 8 columns but found 43 - extras ignored
sqlite>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
