CSV copy not correct (if the comma is in the results)

Brian DonahueBrian Donahue Posts: 6,590 New member
Hi Fred,

Thanks for pointing this out. According to the Excel CSV specification,
any fields of data containing a comma have to be enclosed in quotes, and any
embedded quotes in there have to be 'escaped' with a quote.

I will submit the change to development, and hopefully a fix will be out
soon.

Thanks,

Brian Donahue
Red Gate Technical Support

"Fred" <[email protected]> wrote in message news:[email protected]
> LS,
> Another 'bug'-report. If I have differences in columns with a comma in
them
> (like "Gates, Bill" for a name column, but it could be a number as well)
the
> generated CSV isn't correct...Since the comma is the seperation character
> too I have too many columns on some rows. Could you correct this. Since
CSV
> is an old standard I asume there is already some definition giving the
> solution for this problem...
>
> Gtx,
> Fred
>
>
This discussion has been closed.