Dennis Cote wrote:
John Machin wrote:
U what about quoting the quote character? Line-ending characters
e.g. \r and \n?
sqlite> .mode csv
sqlite> select 1, 'He said "Hello".', 3;
1,"He said "Hello".",3
should be
1,"He said ""Hello"".",3
John,
This works for me using sqlite 3.5.3
John Machin wrote:
U what about quoting the quote character? Line-ending characters
e.g. \r and \n?
sqlite> .mode csv
sqlite> select 1, 'He said "Hello".', 3;
1,"He said "Hello".",3
should be
1,"He said ""Hello"".",3
John,
This works for me using sqlite 3.5.3
sqlite> .mode csv
Kees Nuyt wrote:
On Wed, 19 Dec 2007 00:14:42 +1100, T <[EMAIL PROTECTED]>
wrote:
I think I've discovered yet another bug in the CSV output using the
sqlite3 command line tool.
Here's a sample of the new bug:
.mode csv
select 'a=1,234', 'b=5';
gives:
a=1,234,b=5
but should give:
Thanks! It works.
Joanne
- Original Message
From: Kees Nuyt <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Tuesday, December 18, 2007 10:23:35 AM
Subject: Re: [sqlite] Re: Error in SQLite's CSV output
On Tue, 18 Dec 2007 09:58:55 -0800 (PST), Joanne Pham
<[EMAIL
On Tue, 18 Dec 2007 09:58:55 -0800 (PST), Joanne Pham
<[EMAIL PROTECTED]> wrote:
>Hi All,
>Is there any way that we can export the data to CSV format to the disk.
>Thanks,
>Joanne
I wonder what you tried yourself.
Oh, well.
sqlite3 mydb
SQLite version 3.5.4
Enter ".help" for instructions
Hi All,
Is there any way that we can export the data to CSV format to the disk.
Thanks,
Joanne
- Original Message
From: Kees Nuyt <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Tuesday, December 18, 2007 8:11:08 AM
Subject: Re: [sqlite] Re: Error in SQLite's CSV output
On Wed, 19 Dec 2007 00:14:42 +1100, T <[EMAIL PROTECTED]>
wrote:
>> I think I've discovered yet another bug in the CSV output using the
>> sqlite3 command line tool.
>>
>> Here's a sample of the new bug:
>>
>> .mode csv
>> select 'a=1,234', 'b=5';
>>
>> gives:
>> a=1,234,b=5
>>
>> but should
T wrote:
I think I've discovered yet another bug in the CSV output using the
sqlite3 command line tool.
Here's a sample of the new bug:
.mode csv
select 'a=1,234', 'b=5';
gives:
a=1,234,b=5
but should give:
"a=1,234",b=5
Since no replies, I'll assume this is a bug. I've reported it as:
I think I've discovered yet another bug in the CSV output using the
sqlite3 command line tool.
Here's a sample of the new bug:
.mode csv
select 'a=1,234', 'b=5';
gives:
a=1,234,b=5
but should give:
"a=1,234",b=5
Since no replies, I'll assume this is a bug. I've reported it as:
Hi All,
Back in October I posted:
It seems that the csv output from SQLite has a major problem/error.
Within CSV format, a quote should be returned as a double quote,
within quotes. For example, if I have a field containing:
I said "Hi there"
then the CSV representation should be:
"I
10 matches
Mail list logo