ExcelExport icon indicating copy to clipboard operation
ExcelExport copied to clipboard

How can I escape a comma in data csv file?

Open Vijaykumarj opened this issue 2 years ago • 0 comments

Hi, I wrote a script to create a CSV file which uses CSVResult. So, the output should be 'pretty' (data displayed in separate columns). All is well but data splits when there is a 'comma' within the data. I was appended the data within the double quotes and tried with different ways even though data splits in Microsoft excel. Is there anyway workaround solution for this ?

PFA screenshot for your reference.

image

Vijaykumarj avatar Sep 05 '22 14:09 Vijaykumarj