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 ?
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.