Hello, looking for some help i have tried searching for the answer but cant really find exactly what I'm looking for.
I have a string with either A or T separated by a comma and want to display TRUE if A is displayed only 1 time in the string.
i posted an example table below...
Theres an ID with the string of the status either A or T. looking to show TRUE if A only displays 1 time in the string, if the A shows more than 1 time it would display FALSE.
example pre table
ID | status |
S08652 | T,T,A |
S01234 | A,A,A,T |
S05678 | A,T |
CC9878 | T,A,A |
AA45621 | T,A,T |
CC08754 | A,T,A,T |
S05425 | A,T,A,A,A |
CC54321 | T,T,A,A |
Example of output desired
ID | status | Match |
S08652 | T,T,A | TRUE |
S01234 | A,A,A,T | FALSE |
S05678 | A,T | TRUE |
CC9878 | T,A,A | FALSE |
AA45621 | T,A,T | TRUE |
CC08754 | A,T,A,T | FALSE |
S05425 | A,T,A,A,A | FALSE |
CC54321 | T,T,A,A | FALSE |
Any help would be appreciated.
thank you.
Solved! Go to Solution.
Hi @Nmassarone ,
Try using the Regex_CountMatches function in the formula tool. That will count how many As are contained within your status column
Hope that helps,
Angelos
This is a case where a RegEx does the job pretty clearly:
!(Regex_Countmatches([status],"A") > 1)
NOT Count of A > 1
Cheers,
Mark
@AngelosPachis @MarqueeCrew Thank you both these both perfect thank you so much for the help on this appreciate your time.