Forum Discussion

AdamKrzyzanek's avatar
AdamKrzyzanek
Qrew Captain
3 years ago

Search And Replace to Remove "enters"

I have field where users can enter data and divide them by using Enter:

XXXXXX
YYYYYY

For another field summary I would like to convert this way of entering into:
{XXXXXX; YYYYYY}

I was thinking to use formula "SearchAndReplace" but I am not sure what to enter in Search for?:

 SearchAndReplace([1-Step feeder(s) - after AltBOM],"?????","; ")


In excel I would search for Char(10) but how to find "Enter" in QuickBase?

I tried to Trim, but does not work.
I tried to use in formula enter but after save it is converted to "/n "

Any ideas how to search and replace "ENTER" between numbers?

There might be more then 1 enter.



------------------------------
Adam Krzyzanek
------------------------------
  • 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
    ------------------------------
    • AdamKrzyzanek's avatar
      AdamKrzyzanek
      Qrew Captain
      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
      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
      ------------------------------
      • AdamKrzyzanek's avatar
        AdamKrzyzanek
        Qrew Captain
        I tried both and not working :(

        SearchAndReplace(Trim(SearchAndReplace(Trim([1-Step feeder(s) - after AltBOM]),"/n","| ")),"/r","| ")​​
        And
        SearchAndReplace(Trim([1-Step feeder(s) - after AltBOM]),"\n","| ")​

        Result :(


        ------------------------------
        Adam Krzyzanek
        ------------------------------