Wrapping Colums in Double Quotes

[adam_mc]

I have a requirement to run a report as a data dump to a .csv file where every column is wrapped in double quotes.

Each column is defined as '"' || cast([Data Item] as varchar(256)) || '"'.

This works perfectly when the report is run to HTML, but when run to .csv, only the first column is wrapped in single double quotes. All other subsequent columns are wrapped in triple double quotes!

Any thoughts on how to resolve or explain the post first column behavior would be greatly appreciated.
Thanks in advance,
Adam.

[dougp]

What is the expected outcome?  Are you just trying to get the CSV file to look like...


"a","b","123","2025-02-20","Hello, World!", "She said, ""I meant 20 widgets"""

...but you are getting...

"a",b,123,2025-02-20,"Hello, World!", "She said, ""I meant 20 widgets"""

...or...

a,b,123,2025-02-20,"Hello, World!", "She said, ""I meant 20 widgets"""

...?