Forum Discussion

alex_panganiban's avatar
alex_panganiban
Contributor
3 years ago

LF's in CSV to result in a Multi-Line Cell in Excel

Could use some advice here. I am trying to take a string of data (a group of key/value pairs) that is comma delimited and insert it into a single Excel cell so that it shows as multiple lines within ...
JensDeveloper's avatar
JensDeveloper
Contributor II
3 years ago
Copy LinkReport

Hi @alex.panganiban.guild

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

alex_panganiban's avatar
alex_panganiban
Contributor
3 years ago
Copy LinkReport

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.

  • alex_panganiban's avatar
    alex_panganiban
    Contributor
    3 years ago
    Copy LinkReport

    Hi. I got this figured out. The problem was in Excel, where the cell’s height wasn’t automatically adjusting to the height of the data, so only the first line was displaying, and the remaining lines were obfuscated. Thanks for the assist!