--
Von: sqlite-users
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von
Ketil Froyn
Gesendet: Mittwoch, 14. Juni 2017 10:03
An: SQLite mailing list
Betreff: Re: [sqlite] Outputting to CSV - row is not quoted when there
are no spaces
Dan, I'd recommend using a tool that actually und
Thanks Ketil I'll definitely take a look!
FYI my script is available here: https://github.com/64b2b6d12b/spotkey
Thanks,
Dan
On 2017-06-14 18:02, Ketil Froyn wrote:
Dan, I'd recommend using a tool that actually understands CSV, and
make it parse the input and create new quoted output. I haven'
etreff: Re: [sqlite] Outputting to CSV - row is not quoted when there are no
spaces
Dan, I'd recommend using a tool that actually understands CSV, and make it
parse the input and create new quoted output. I haven't seen your sed and awk,
but I'm pretty sure it's easy to find som
Dan, I'd recommend using a tool that actually understands CSV, and
make it parse the input and create new quoted output. I haven't seen
your sed and awk, but I'm pretty sure it's easy to find some special
cases where the text includes comma, quotes or even newlines that will
break your output.
A s
Thanks Richard, in the end I added the quotes using some SED and AWK as
I'm using SQLite as part of a BASH script.
Thanks
On 2017-06-13 14:36, Richard Hipp wrote:
SQLite does not provide that capability, that I recall.
But surely it would not be too difficult for you to do your own custom
pat
SQLite does not provide that capability, that I recall.
But surely it would not be too difficult for you to do your own custom
patch, or even to write a short program to output the data in the
precise format you desire?
On 6/12/17, d...@dan.bz wrote:
> Hi,
>
> When outputting to CSV with '.mode
Hi,
When outputting to CSV with '.mode csv' is there a way that all rows can
be quoted even if there are no spaces? For example, here is a 1 line
from the output:
spotify:track:5vlDIGBTQmlyfERBnJOnbJ,Kiso,Circles,100.019
I would like it to output:
"spotify:track:5vlDIGBTQmlyfERBnJOnbJ","Kis
7 matches
Mail list logo