Filter Number + Alphabet combination from dataset

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

Regex

Accepted answers

MarqueeCrew

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

All comments

MarqueeCrew

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

MikeLR

I can see I need to make regex part of my world!

Nezrin

@MarqueeCrew - the RegEx pro!

Redzapplin

You are awesome!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

hhaigh1 280