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

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 : )

extend filter.yxmd