ZohoDeluge: Inserting a new line character in a CSV

: Joel Lipman; Zoho; 01 March 2023; Hits: 2785

What?
A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge.

Why?
My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"...

What I have

copy raw

Me,Myself,I\na,b,c

Me,Myself,I\na,b,c

What I want

copy raw

Me,Myself,I
a,b,c

Me,Myself,I
a,b,c

How?
So in this article I just want to list some various methods of inserting a new line character.

Works on most systems:

copy raw

l_CsvFileRows = List();
l_CsvFileRows.add("Me,Myself,I");
l_CsvFileRows.add("a,b,c");
//
v_CSVFilename = "Test.csv";
f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename);
//
// sometimes works but sometimes yields:
// Me,Myself,I\na,b,c

l_CsvFileRows = List();
l_CsvFileRows.add("Me,Myself,I");
l_CsvFileRows.add("a,b,c");
//
v_CSVFilename = "Test.csv";
f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename);
//
// sometimes works but sometimes yields:
// Me,Myself,I\na,b,c

Works on systems where the above doesn't work:

copy raw

l_CsvFileRows = List();
l_CsvFileRows.add("Me,Myself,I");
l_CsvFileRows.add("a,b,c");
//
v_CSVFilename = "Test.csv";
f_CSVFile = l_CsvFileRows.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename);
//
// yields:
// Me,Myself,I
// a,b,c

l_CsvFileRows = List();
l_CsvFileRows.add("Me,Myself,I");
l_CsvFileRows.add("a,b,c");
//
v_CSVFilename = "Test.csv";
f_CSVFile = l_CsvFileRows.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename);
//
// yields:
// Me,Myself,I
// a,b,c

Additional

Adding to a screen output: eg. a button response or response of info: try holding down the ALT key and pressing 255, then releasing the ALT key and save the change to your code. This will not display a character but is a new line...
Used in certain cases
copyrawstyler
```
v_NewLineChar = hextoText("0A");
```
1. v_NewLineChar = hextoText("0A");
Thought I needed to add the following but this makes absolutely no difference:
copyrawstyler
```
f_CSVFile.setCharSet("UTF-8");
f_CSVFile.setFileType("csv");
```
1. f_CSVFile.setCharSet("UTF-8");
2. f_CSVFile.setFileType("csv");