On Thu, Jun 27, 2013 at 8:58 AM, Richard Hipp <d...@sqlite.org> wrote:
> > What if, instead of a new command, we simply extend the ".import" command > so that if the first character of the filename is "|" it interprets the > filename as a pipe instead of a file. The ".output" command works that way. > This alternative concept has now been implemented on trunk. Example: script1.awk is: BEGIN { print "x,y" for(i=1; i<=10; i++){ print i ",this is string " i } exit(0); } Then run: drh@tallis:~/sqlite/bld$ ./sqlite3 SQLite version 3.8.0 2013-06-27 14:07:53 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .mode csv sqlite> .import '|awk -f script1.awk' t1 sqlite> select * from t1; 1,"this is string 1" 2,"this is string 2" 3,"this is string 3" 4,"this is string 4" 5,"this is string 5" 6,"this is string 6" 7,"this is string 7" 8,"this is string 8" 9,"this is string 9" 10,"this is string 10" sqlite> -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users