I want to filter on values that start with number and end with an alphabet

[swarajjoshi]

I have column like this:

Record No.	Testing
1	3025155M
2	A545621E
3	PSHDBDP
4	2021232D
5	50451455

I want to add a filter in "Testing" which will only select values that starts with number and end with an alphabet, so from above example I want the 1st & 4th value i.e. 3025155M & 2021232D.

Note:- The number and alphabet will keep changing

[atcodedog05]

Hi @swarajjoshi 

You can use this regex formula in filter tool

REGEX_Match([Testing], "\d.*\u")

Hope this helps 🙂

[estherb47 · Accepted solution]

Hi @swarajjoshi 

You can try something like this:

REGEX_Match([Testing], "\d.*[a-zA-Z]")

RegEx Match will look to match the entire string. The statement inside the quotes is starts with a digit and ends with an alpha.

Let me know if that works.

Cheers!

Esther

[atcodedog05]

Hi @swarajjoshi 

After seeing @estherb47 i remembered a approach which i learnt from her.

Use this in Filter tool.

REGEX_Match([Testing], "\d.*\D")

\D checks that the string doesnt end with number

Workflow:

Hope this helps 🙂

[swarajjoshi]

Hey @estherb47  Thanks for your response.
It really worked well, thanks a lot

[swarajjoshi]

Thanks for your response too! @atcodedog05 

That also helped a lot.