How to preserve line breaks when switching a field from String to HTML

[Stefan Reichelt]

When I change an existing String field (like Description or Resolve Notes) from String to HTML, all the line breaks within existing entries get lost.

What's the best way to prevent that? Do I have to run some update script over the whole table before converting, or is there an easier way?

[Alberto Consonn]

Yes, this is the only way, you could also try to reduce the amount of line, simply adding the last year close notes for example, in this way you can start doing the migration of the last year data and so on with the others.

If I have answered your question, please mark my response as correct.

Thank you very much

Cheers
Alberto