Match if Letter Character shows ONLY one time in a string

[Nmassarone]

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.

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

[MarqueeCrew · Accepted solution]

@Nmassarone 

This is a case where a RegEx does the job pretty clearly:

!(Regex_Countmatches([status],"A") > 1)

NOT Count of A > 1

Cheers,

Mark

[Nmassarone]

@AngelosPachis @MarqueeCrew  Thank you both these both perfect thank you so much for the help on this appreciate your time.