Did you try explicitly declaring your separator via .separator command? You should be able to importing the line with quotas included in it.
http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles ________________________________ From: Spora <[email protected]> To: [email protected] Sent: Wednesday, April 24, 2013 2:11 PM Subject: [sqlite] import with quotation mark Last Sqlite is not able to import line as this: 01010 aaaaaa 16020 bbbbb'bbbbbb"cccccc, 33 dddd eeeee fff 31/03/13 Error: file.txt line 298: expected 9 columns of data but found 8 With previous version i not have this problem. Do it is possible to add a switch to ignore '"' when import? -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f Sponsor: Offerta speciale PEC per ditte individuali e liberi professionisti, sconto del 20% se attivi ora! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=12827&d=24-4 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
