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

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
20 - Arcturus

@WynnT  this can be achieved using a filter tool

 

binuacs_0-1642715119791.png

 

binuacs
20 - Arcturus

@WynnT using Regex

 

binuacs_0-1642715864578.png

 

 

WynnT
5 - Atom

@binuacs Thanks so much!

Labels