CSV copy not correct (if the comma is in the results)
Brian 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
soon.
Thanks,
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
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
>
>
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" <No@Thanks.com> wrote in message news:om3VhQFuDHA.2820@server53...
> 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.