Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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