You need to update your expression to
$dataString.replace(/,/g, “\n”)
This modification will replace the commas with line feed characters, resulting in the following formatted string:
{
dataString:
“key1:value1\n key2:value2\n key3:value3”
}
After using the csv formatter and file writer the excel file looks like this:
Let me know if this helps
Regards
Jens
Thanks, Jens. So I had tried this solution before and again after you posted. Unfortunately, what I get is a truncation after the first line feed. I get the first key/value pair in the cell, but lose the remaining data in my string. I’ll try and play around some more and see if I can send you an actual sample of what I’m doing.
Thanks.
