How can I escape a comma in data csv file?

[Vijaykumarj]

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.

[webbrain-one]

Hi! Thanks for raising this. I’ve opened a pull request (#13) to fix the comma-escaping behavior so CSV fields containing commas are properly quoted and won’t split into extra columns. This should make the output display correctly in Excel.