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.
¡Resuelto! Ir a solución.
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.