MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2013

Re: AW: SQL output to csv



fixed

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





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact