What are the challenges you face when working across database platforms? Take the survey

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

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
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


Brian Donahue
Red Gate Technical Support

"Fred" <No@Thanks.com> wrote in message news:om3VhQFuDHA.2820@server53...
> LS,
> Another 'bug'-report. If I have differences in columns with a comma in
> (like "Gates, Bill" for a name column, but it could be a number as well)
> 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
> is an old standard I asume there is already some definition giving the
> solution for this problem...
> Gtx,
> Fred
This discussion has been closed.