Forum Discussion

MikeMike's avatar
MikeMike
Qrew Cadet
6 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

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
6 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
    2 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
    ------------------------------