Forum Discussion

JonathanHeuer's avatar
JonathanHeuer
Qrew Cadet
6 years ago

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...
Formulas and functions
DonLarson's avatar
DonLarson
Qrew Elite
6 years ago
Jonathan,

A QB if statement will escape when it hits the first True condition.  Imagine a record where both are present, this will only get the first one.

I suggest exporting all the records and writing a short PHP script to go through the entire data set and change both.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
JonathanHeuer's avatar
JonathanHeuer
Qrew Cadet
6 years ago
Thanks for suggestion Don. No hablo PHP but perhaps I can open in some text editor and try the search/replace feature.

------------------------------
Jonathan Heuer
------------------------------