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:)
Solved! Go to 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 : )
@atcodedog05 Thank you so much , works perfectly fine:)
Happy to help : ) @Ekta
Cheers and have a nice day!