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
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
try this logic

var text ReplaceN =SearchAndReplace([Description of Service], "\n", "<br>")
SearchAndReplace($ReplaceN, "\r", "<br>") 


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • JonathanHeuer's avatar
    JonathanHeuer
    Qrew Cadet
    6 years ago
    Thanks Mark. I tried your suggestion and doesn't work. When you try saving the formula QB takes out the second escape.

    ------------------------------
    Jonathan Heuer
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      Can you try this

      var text ReplaceN =SearchAndReplace([Description of Service], "\\n", "<br>")
      SearchAndReplace($ReplaceN, "\\r", "<br>") 


      ie try a double backslash

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------