I'm trying to figure how to flag a record if a concatenated string contains something OTHER THAN a given value. I don't know all the values a cell may have, otherwise I would just use a contains and search for those values to flag it.
For example:
I want to flag a cell if it contains ANY value OTHER THAN just "A".
Field value: A,B,A,C,D,G,H. <-- this would be flagged
Field value: A,A,Z <-- this would be flagged
Field value: A,A,A,A,A <--this would NOT be flagged
Thanks,
Craig
Solved! Go to Solution.
I'd use RegEx match:
This regex basically says, the string will match true if it only contains commas or the letter A (or lowercase a) @csh8428