This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi All,
How to handle comma in the string when creating a CSV file.
I have an address field in my data, which is placed in another cell.
Thanks

You'll probably need to be using quotes or double quotes to separate your column data.

I tried like
searchResult.replace(/,/g, '","') +',';
searchResult.replace(/,/g, '\,') +',';
do I need any modifications

there is also an escape character on the chance your csv column value contains a double quote

use two double quote ("") to represent a double quote (") in your escaped column values

if this sounds too hard, use <https://www.papaparse.com/|papaparse>