Filter by serial number where there is a letter forth from the right

[iskinner]

I’m working with a random set of serial numbers and I need to filter (true/false) where there is a letter forth from the right.

Sample

AUL28774C404

6EKL-1075574

3NSTAA992LN947973

HEW43437C707

5Y4AN27Y2LA106792

1C6LA000877

MB2X8334G819

Desired outcome

AUL28774C404

HEW43437C707

MB2X8334G819

Any help is greatly appreciated!

[bpatel · Accepted solution]

hi @iskinner ,

you can try a formula to get the last four characters then use regex

hope this helps!

[iskinner]

hi @bpatel ,

It's not exactly what I was thinking but it does work out. Thanks so much!