for Exact match, you just need the calculation like
[Multi-Search] = [State]
Thanks for the reply.
But the [Multi-Search] here is a string like " LA|SF|NYC" which contains several states and being separated by delimiter.
I'm thing to split the string first and do exact match however cities inside the string can be dynamic.
Do you have any idea?
I've worked it out ><
Just add ^$ to the string and REGEX would be exact match!!!
e.g. "^ LA$|^SF$|^NYC$"