SSRS CSV Export with Quotes

[cotton31]

Hi,

Not sure if this is the right place to post this.

I am writing a report in BIDS which needs to have each field enclosed in double quotes, when exported as CSV.

I have tried concatenating the double quote character to either end of the field in both my SQL and layout, but on both occasions this produces a set of quotes around the quotes I've added as below:

""" fieldname """ , """ fieldname """

Anybody come across this before and have a workaround for it?

Cheers,

 

[namnoc]

I haven't used BIDS, but the usual solution for something like this is to use a different character such as ^ in place of the quotes and export that to a CSV. Then use whatever program you like to do a search and replace to change all the ^ to ".