We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

How to use Regex to extract only account numbers starting with number 4

WynnT
5 - Atom

Hi,

 

I have a couple of account numbers showing below. Is there a way to use Regex to match only accounts starting with #4 . The output should show only 2 accounts per the below. Thanks so much!

12356

45255

84568

47854

12548

35587

3 REPLIES 3
binuacs
17 - Castor

@WynnT  this can be achieved using a filter tool

 

binuacs_0-1642715119791.png

 

binuacs
17 - Castor

@WynnT using Regex

 

binuacs_0-1642715864578.png

 

 

WynnT
5 - Atom

@binuacs Thanks so much!

Labels