MikeMike
7 years agoQrew Cadet
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 values.
The problem I have encountered is that two of the values in the first formula field contain an ampersand - & - and my new formula field does not seem to see those values, and so is ignoring them when producing the output values.
eg.
This
That
This & That
My formula
Do I need to somehow escape the ampersand to make it find them in my other field? I have tried different ways I could think of:
The problem I have encountered is that two of the values in the first formula field contain an ampersand - & - and my new formula field does not seem to see those values, and so is ignoring them when producing the output values.
eg.
This
That
This & That
My formula
If([ex field] = "This", "One", [ex field] = "That", "Two", [ex field] = "This & That", "Three")However my output gives me a "One" and a "Two" but for the values that should be "Three" it just shows as "<empty>"
Do I need to somehow escape the ampersand to make it find them in my other field? I have tried different ways I could think of:
If([ex field] = "This \& That", "Three")Is there something else I need to use to make my formula work? Unfortunately it is too late to go back to the other field to replace the & with an "and"
If([ex field] = "This && That", "Three")
If([ex field] = "This & That", "Three")