Rich, I tried both of your suggestions. Both worked correctly.
Thanks for the extra information, Lee Crain ______________________ -----Original Message----- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Monday, August 13, 2007 5:29 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File On Mon, 13 Aug 2007, Rich Shepard wrote: > And does it work if you specify "\t" as the spacer? Lee, Better yet, try this from the command line: .m tabs .o myfilename.txt select * from mytable .m list .o stdout The .mode command allows you to specify tabs as the values separator, just like the .separator string does. If the latter is not working, the former should. Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 -------------------------------------------------------------------------- --- To unsubscribe, send email to [EMAIL PROTECTED] -------------------------------------------------------------------------- --- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
