I am writing a bunch of CRM fields in to a CSV using the insertCSV function. My issue is if the field is blank. Instead of inserting nothing, it inserts the word "null".
I've tried using zoho.sheet.replace(sheetid,"worksheet","null","") but this gives me an error - it doesn't like replacing with "".
Is there a way to insert nothing if the field is blank?
Any thoughts?