How do I preserve line breaks when converting multi-line text field to rich text field?
We have a few thousand records in a table with a multi-line text field. The data in the text field often has lines breaks in order to make the content easier to read, some of them containing lists for...
You need to replace each newline character (ie \n) in the Text field with <br > tags in the Rich Text field. This can be done with script using the general procedure used in this Pastie:
Here is a screenshot of me editing a modified record after manually applying similar code from the console:
As this code could modify every record in a table you should only use it if you are comfortable with using JavaScript. I would further suggest you work in a copy of your production application.
If you need personalized assistance you can contact me via the information in my profile:
