How to flag a record if a concatenated string contains something OTHER THAN a given value?

[csh8428]

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

[Luke_C]

Hi @csh8428 

You could split the data to rows then count the distinct values to do this.

[BS_THE_ANALYST · Accepted 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 

[flying008]

Hi,@csh8428 

You can use the formula to filter:

Length(Trim(ReplaceChar([Txt], "A,", ''))) > 0