Filter tool formula

[Ekta]

Dear all, 

Please help me with below query-

In my dataset i have a column where the data should always be like A123B, means first and fourth letter are alphabets and middle 3 are numbers, Sometime due to readability issue , 3 in A123B is read as A12BB or 8 can be read as B etc,  i would like to filter it out when this happens.

Please help me with the filter formula for this.

My current filter formula !IsEmpty([A]) and !IsEmpty([B]) and !IsEmpty([C]) and !IsEmpty([D])

i would like to add one more condition on column E ie if E is (first and fourth letter are alphabets and middle 3 are numbers ) then its good to go else no.

A	B	C	D	E
John	12	Apple	34	A12BB

Thank you in advance:)

[atcodedog05 · Accepted solution]

Hi @Ekta 

The extended filter formula would be

!IsEmpty([A]) and !IsEmpty([B]) and !IsEmpty([C]) and !IsEmpty([D]) and REGEX_Match([E], "\u\d{3}\u")

Workflow:

Hope this helps : )

[Ekta]

@atcodedog05 Thank you so much , works perfectly fine:)

[atcodedog05]

Happy to help : ) @Ekta 

Cheers and have a nice day!