On Thu, Jul 30, 2015 at 3:40 PM, Sylvain Pointeau < sylvain.pointeau at gmail.com> wrote:
> > Well ... I am glad that you are right. > > When I saw your message, I wondered why it didn't work for me. > > I have taken back my samples: > > $ cat test.csv > A,B,C > T,TI,TIT > "A,B",C,D > "1st line > 2nd line",E,F > > sqlite> .mode csv > sqlite> .import test.csv T > sqlite> select * from T; > T,TI,TIT > "A,B",C,D > "1st line > 2nd line",E,F > > I think this is where my mistake comes from, and when I did browse on > internet, I saw some replies showing how to do an update to remove the > quotes... > > now I should have done: > > sqlite> .mode csv > sqlite> .import test.csv T > sqlite> .mode list > sqlite> select * from T; > T,TI,TIT > A,B,C,D > 1st line > 2nd line,E,F > 0003,002,01 > > so I was obviously wrong, sqlite import the csv very well, and I am glad to > have been wrong! > > apologies for my mistake. > ?Well, I made the identical mistake myself on my first try. But then I noticed in the manual that the ".mode csv" also affected how the output from a SELECT was displayed. That's when I tried the ".mode lines" just to see what happened. The light then came on. ? > > Best regards, > Sylvain > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
