Regex Challenge : Parsing out values that start with 5 numbers

[waqaraphoto]

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!

[MarqueeCrew]

@waqaraphoto,

A quick solution...

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

Cheers,

Mark

[waqaraphoto]

That worked! @MarqueeCrew. Thanks for your help! :)

[MarqueeCrew · Accepted solution]

@waqaraphoto,

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

Cheers,

Mark