My intended process would be:
- Transform existing multiline data into a new field with <br> tags using a formula like
If(Contains([Description of Service], "\n"),SearchAndReplace([Description of Service], "\n", "<br>"),Contains([Description of Service], "r"),SearchAndReplace([Description of Service], "r", "<br>"),[Description of Service]) - Export all records in table
- Change field type of the original field to rich text
- Import data into transformed field
- Live happily every after.
------------------------------
Jonathan Heuer
------------------------------