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.
Thank you in advance:)