Regex Challenge : Parsing out values that start with 5 numbers

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!

parsing ins ids.PNG

Regex

Parse

Accepted answers

I originally read this as identify and modified the solution to provide you with the 5 digit value via regex_replace.

Cheers,

Mark

All comments

A quick solution...

regex_replace([title],"(\d{5}).*",'$1')

Cheers,

Mark

That worked! @MarqueeCrew. Thanks for your help!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703