JonathanHeuer
6 years agoQrew Cadet
Converting from multi-line to rich text field without losing line breaks
I'd like to change the field type of an important field from multi-line to rich text. I have thousands of records with valuable data in this field, and don't want to lose existing line breaks. Despite the suggestion made in this other discussion thread, it doesn't work to simply replace "/n" with "<br>". According to QB Support, some of the line breaks are represented by "\r". And if you try substituting "\r" in a text formula, it breaks.
My intended process would be:
------------------------------
Jonathan Heuer
------------------------------
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
------------------------------