> -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf > Of Richard Hipp > Sent: Thursday, June 27, 2013 9:16 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] sqlite3: .import command handles quotation incorrectly > > 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.
<snip> Dang, you're quick :) This opens a lot of possibilities for me and I don't have to patch shell.c any more <G> One of the handiest uses is importing directly from .xls via Perl and Spreadsheet::ParseExcel and the xls2csv( ) function ... Thank you, Richard !! -- kjh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
