Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter Number + Alphabet combination from dataset

Redzapplin
8 - Asteroid

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
4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
MikeLR
8 - Asteroid

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

Nezrin
11 - Bolide
11 - Bolide

@MarqueeCrew - the RegEx pro!

Thanks,
Nez
Alteryx ACE | Sydney Alteryx User Group Lead | Sydney SparkED Contributor
Redzapplin
8 - Asteroid

You are awesome!

Labels