It still is not working... Terminal does not add a tab character with ctrl-v. I even tried pasting one... but in both cases the error bell rings!
Merci pour l'aide ;-) S. --- On Thu, 7/24/08, Schplurtz le déboulonné <[EMAIL PROTECTED]> wrote: > From: Schplurtz le déboulonné <[EMAIL PROTECTED]> > Subject: Re: [sqlite] .separator \t not working > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Thursday, July 24, 2008, 7:51 AM > Hello, > Le 24 juil. 08 à 01:28, none given a écrit : > > > I then attempt the 3 variations of the statement as > such : > > sqlite3 test.db ".separator '\t' > .import data.csv wc2" > > sqlite3 test.db ".separator \t .import > data.csv wc2" > > sqlite3 test.db ".separator '\t' > \n .import data.csv wc2" > [snip] > > What am I doing wrong? > > > I think you can enter only one dot command, so use the > -separator > option. > > And sqlite has a strange behaviour with \t on command > line, you > must give a REAL tab to the -separator option. On command > line, use > Control-v <TAB> to insert a real TAB. The command > should look like > this : > > sqlite3 test.db -separator ' ' test.db > ".import data.csv wc2" > > Check > http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2008-July/004448.html > for how to do it from a program. > > /schplurtz > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users