Rich, I actually keyed a TAB character, not spaces.
Thanks for your response, Lee Crain _______________________ -----Original Message----- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Monday, August 13, 2007 4:22 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, Lee Crain wrote: > No, I'm on Windows XP. My condolences. > I am running SQLite 3.3.17. And I did enter exactly: separator ' '; > where the gap between the single quotes is an actual T A B character. > Maybe that's cheating. :^) Lee, Only yourself. The '\t' (or use double quotes to keep Gates and Balmer happy) is the standard ASCII code for a tab. The number of spaces in a tab is not universally fixed at the same width, and spaces are not equal to a tab. When you're in the sqlite command line editor, type .h to see all the help. The .mode command is also useful when dumping or exporting to a disk file. 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] -----------------------------------------------------------------------------
