Hi
Thanks for replying. I have numbers too in my column, using this formula it returns the digits too which i don't want. Please see below my column data.
I need to identify only characters like '73-HQ' (number + alphabets)
LIT99 |
ADFOP |
4050932 |
4052191 |
4065666 |
4073599 |
69-HQ |
73-HQ |
1/HQ |
73--HQ |
Solved! Go to Solution.
Here's regular expression for you:
regex_match([field],"\d\d-\u\u")
two digits dash two uppercase letters (any letters, because case sensitivity is off).
cheers,
mark
I can see I need to make regex part of my world!
@MarqueeCrew - the RegEx pro!
You are awesome!