I am attempting to use Contains to find text. I have attached an example. I would expect both records to return true. Why would they not, isn't contains looking for an instance of the string not an exact match?
Solved! Go to Solution.
You have your string and field the wrong way round. CONTAINS([Field1],'Jason') is what you're after
Hi @doublej
The first thing to be evaluated is your Field. The string "target" should be "Jason".
The original function is Contains(String, Target)
Cheers,
that was it. I was thinking that when I saw the structure as Contains(String,Target) it was the string I was looking for in the field (target). thanks!