On Tue, 14 Aug 2007, Lee Crain wrote:
I tried both of your suggestions. Both worked correctly.
Yea, team! Glad you learned something useful, Lee.
Rich
--
Richard B. Shepard, Ph.D. |The Environmental Permitting
Applied Ecosystem Services, Inc.| Accelerator
] 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 mytab
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
lik
On Mon, 13 Aug 2007, Lee Crain wrote:
I actually keyed a TAB character, not spaces.
Lee,
And does it work if you specify "\t" as the spacer?
Rich
--
Richard B. Shepard, Ph.D. |The Environmental Permitting
Applied Ecosystem Services, Inc.| Accelerator(TM)
ject: RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB
Character Delimited Text File
Regarding
.separator "\t"
Vs
.separator '\t'
Cool. BTW, It seems to require double quotes for me, running Windoze
XP, sqlite3.exe version 3.4.0, else the separator
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 a
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
iggs, Donald [mailto:[EMAIL PROTECTED]
Sent: Monday, August 13, 2007 3:37 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
Regarding
.separator "\t"
Vs
.separator '\t'
Cool. BTW,
Regarding
.separator "\t"
Vs
.separator '\t'
Cool. BTW, It seems to require double quotes for me, running Windoze
XP, sqlite3.exe version 3.4.0, else the separator becomes literally a
backslash followed by the letter t. I'm guessing you're using *NIX
and guessing it requires single quot
ECTED]
Sent: Monday, August 13, 2007 2:34 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
Hi Lee,
Regarding: ...I need to export a table from a SQLite database as a TAB
character delimited text file.
Try the f
Hi Lee,
Regarding: ...I need to export a table from a SQLite database as a TAB
character delimited text file.
Try the following
.separator "\t"
.output ExportFile.txt
select * from MyTable;
.output stdout
-
To unsubsc
11 matches
Mail list logo