Luc Charansonney wrote: > sqlite> .separator tabs sqlite> select 1, 2; 1tabs2
> sqlite> .import mydata.txt mytable > Error: multi-character column separators not allowed for import You should have used ".separator \t". > So I fall back on my feet by using .mode instead of .separator: > sqlite> .mode tabs > sqlite> .import mydata.txt mytable The .mode command expects a name, but .separator the actual characters. The modes have more differences than the separators, but that's mostly for output. As far as .import is concerned, the only mode with special behaviour is "ascii" (which does not use CSV quoting rules). Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
