I use: .separator "\t" but not solve, it works only when not have quotation.
Fehmi Noyan ISI ha scritto quanto segue il 24/04/2013 6.48>
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 <sp...@email.it> *To:* sqlite-users@sqlite.org *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 sqlite-users@sqlite.org <mailto:sqlite-users@sqlite.org> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-- 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
