Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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