Clemens Ladisch wrote: >> 2. "separator" changes to "\t", but cannot .import files with "\"": >> >> echo -ne "\"\t" >f && sqlite3 <<EOF >> create table t(a text, b text); >> .separator "\t" >> .import f t >> EOF >> Error: f line 1: expected 2 columns of data but found 1 > >In its import files, sqlite3 always interprets " as quote character.
No, sqlite3 ".separator \t" does not interpret " before 3.7.11: echo -ne "\"\t" >f && for i in 05 06 07 08 09 10 11 12 13 14 ; do wget http://sqlite.org/sqlite-shell-linux-x86-307"$i"00.zip -qO sqlite.zip && unzip -qqo sqlite.zip && ./sqlite3 --version && ./sqlite3 <<EOF create table t(a text, b text); .separator \t .import f t select "Lines in t:",count(*) from t; EOF echo done 3.7.5 Lines in t: 1 3.7.6 Lines in t: 1 3.7.7 2011-06-23 19:49:22 4374b7e83ea0a3fbc3691f9c0c936272862f32f2 Lines in t: 1 3.7.8 2011-09-19 14:49:19 3e0da808d2f5b4d12046e05980ca04578f581177 Lines in t: 1 3.7.9 2011-11-01 00:52:41 c7c6050ef060877ebe77b41d959e9df13f8c9b5e Lines in t: 1 3.7.10 2012-01-16 13:28:40 ebd01a8deffb5024a5d7494eef800d2366d97204 Lines in t: 1 3.7.11 2012-03-20 11:35:50 00bb9c9ce4f465e6ac321ced2a9d0062dc364669 Error: f line 1: expected 2 columns of data but found 1 Lines in t: 0 3.7.12 2012-05-14 01:41:23 8654aa9540fe9fd210899d83d17f3f407096c004 Error: f line 1: expected 2 columns of data but found 1 Lines in t: 0 3.7.13 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc Error: f line 1: expected 2 columns of data but found 1 Lines in t: 0 3.7.14 2012-09-03 15:42:36 c0d89d4a9752922f9e367362366efde4f1b06f2a Error: f line 1: expected 2 columns of data but found 1 Lines in t: 0 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users