Hi Everyone,
In the screenshot attached, I'm trying to create a new field which contains only those Titles that start with a 5 digit number. Can anyone help me do this using regex? I've used the LEFT([String],5) function but that just gave me the left most 5 characters/numbers. I'm not sure how to apply this logic .. perhaps a regex solution can do this.
Thank you!
Solved! Go to Solution.
A quick solution...
regex_replace([title],"(\d{5}).*",'$1')
Cheers,
Mark
That worked! @MarqueeCrew. Thanks for your help! :)
I originally read this as identify and modified the solution to provide you with the 5 digit value via regex_replace.
Cheers,
Mark