Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Identify Cell Beginning with X amount of Numbers

G_WOLAK
7 - Meteor

I have a data set with inbound field 'Name' where I need to identify cells which begin with four numbers.  An example of which is below.

 

'2017 Culture/Engagement Conference'

 

What follows the four digit number is inconsequential.  

 

I've tried searching for solutions in RegEx and the formula tool, but haven't found the solution. 

 

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

Hi @G_WOLAK 

 

Try using the following custom expression in a Filter tool:

 

REGEX_Match([Name],"\d{4}.*")

 

This function will test to see if the value matches the RegEx pattern \d{4}.*. Which is:

\d{4} = 4 digits/number

.* = any amount of other characters

 

I've attached a workflow to show this in action. Let me know if this works for you. 

G_WOLAK
7 - Meteor

Thanks, that worked.  I was close, but had some errors in the syntax.

Labels
Top Solution Authors