Identify Cell Beginning with X amount of Numbers

Question

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 · Accepted Answer

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.