Re: AW: SQL output to csv

On Wed, Dec 4, 2013 at 11:18 AM, Raul A. Jager W. <raul@xxxxxxxxxx> wrote:

to get it in CSV you will have to concatenate the data and the
"comas"

On Wed, Dec 4, 2013 at 11:57 AM, Dan Kimmel <dkimmel@xxxxxxxxxxxxxxx> wrote:

You can always do something like this
[throw in your own double-quotes and commas]

Be very, very careful when rolling your own. It's not always as
simple as you think. Data that contains literal double-quotes are
especially insidious and surprisingly common. The proper way to
handle corner cases depends on who/what is reading the data, and no
one way is universally safe.

I have received more than anyone's fair share of "write-only" CSV data
(easy to write, not easy to reconstitute into the original data).

John