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
Solved! Go to Solution.
Hi @swarajjoshi
You can use this regex formula in filter tool
REGEX_Match([Testing], "\d.*\u")
Hope this helps 🙂
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
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 🙂
Hey @estherb47 Thanks for your response.
It really worked well, thanks a lot
Thanks for your response too! @atcodedog05
That also helped a lot.