Forum Discussion

ServiceQB's avatar
ServiceQB
Qrew Member
3 years ago

Re: Search And Replace to Remove "enters"

Is the field MultiLine or Rick Text?
If it's Multi-Line Text try combos of /r /n

If it is Rich Text, Go into Edit Mode and put your cursor in the field and view the Source code (End of the format panel that appears) That will let you know if it's a break or a paragraph.




------------------------------
Tammie King
tjking@mintz.com
(978)828-9643
------------------------------

7 Replies

  • AdamKrzyzanek's avatar
    AdamKrzyzanek
    Qrew Captain
    3 years ago
    Field from which formula is taking data is [Text (lookup)] from different table, where this field is [Text - Multi-line].

    Formula field which I was using to convert is standard [Formula - Text].

    I modified formula but it did not help.
      SearchAndReplace(Trim(SearchAndReplace(Trim([1-Step feeder(s) - after AltBOM]),"/n","| ")),"/r","| ")​



    ------------------------------
    Adam Krzyzanek
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    The character for new line is actually \n

    so try this

    SearchAndReplace([1-Step feeder(s) - after AltBOM],"\n","; ")​


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------