ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

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

Identify Cell Beginning with X amount of Numbers

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. 


17 - Castor
17 - Castor



Try using the following custom expression in a Filter tool:




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. 

7 - Meteor

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