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.
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. 

 

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