Exporting records to Excel (preserving the newline character)

[NickFaraday]

Hey everyone, 

Just looking to see if anyone has come across a good solution to for this.  

I have a set of records with multiple fields that I need to export to Excel, I'm exporting via script and everything works great with the exception of one of my fields "columns".   This field has a multi-line description.   When exporting, all carriage returns are stripped.   A quick google search turns up some solutions for exporting a single filed and preserving returns but not a group of fields with only one "column" needed the returns preserved.

I'm on FM19 Server. 

Is there a plugin that addresses this issue?

Thx

[comment]

24 minutes ago, NickFaraday said:

When exporting, all carriage returns are stripped. 

That is not my observation. There must be some additional factor at play.