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.
Solved! Go to Solution.
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.
Thanks, that worked. I was close, but had some errors in the syntax.