Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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