Forum Discussion

MikeMike's avatar
MikeMike
Qrew Cadet
7 years ago

Do I need to escape ampersand in a text formula field?

I have an existing formula field which produces a number of text values based on different criteria.  I am now creating a new formula field that looks at the first field to produce a reduced set of va...
Formulas and functions
Tables and fields
EverettPatterso's avatar
EverettPatterso
Qrew Captain
7 years ago

Try something like this

If(Trim(Left([ex field], "&")) = "This" and Trim(Right([ex field], "&")) = "That", "Three", [ex field] = "This", "One", [ex field] = "That", "Two")
  • MikeMike's avatar
    MikeMike
    Qrew Cadet
    7 years ago
    Well that was an unexpected workaround solution, but it worked, thank you!  I am still interested to know if there's a way to escape that character, but until then this has solve my immediate problem.

    Thank you
    • ShawnShawn's avatar
      ShawnShawn
      Qrew Member
      3 years ago

      I had something similar in where I am editing a field by adding a text value containing an ampersand through a URL api link. To get the ampersand to work as text in the formula I substituted the & symbol with %26 and it worked flawlessly.

      Using &amp did not work in my case; everything behind & or &amp in the text string, would get truncated.



      ------------------------------
      Shawn Somerlot
      ------------------------------