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!
