Regex pull specific number out of string of text help

Hello -

I am trying to pull out a certain portion of a file name (see example below). Can anyone help with the appropriate RegEx syntax to pull out this information, and this information only? Or if there is an alternative way other than RegEx that would be appreciated as well.

Thanks!

example string with bolded text being the text I want to extract:

V:\FY18\Connect Support\R109 summary of receivables and payables\Response Documents\3048159_1725_FA_CustomSet_KAPOLLO_924879_31-Oct-2018_05-Nov-2018.pdf

Regex

Accepted answers

MarqueeCrew

@jannis005,

Did you already try this expression?

REGEX_Replace([Field1], ".*\\\d+_(\d+)_.*", '$1')

Cheers,

Mark

All comments

MarqueeCrew

@jannis005,

Did you already try this expression?

REGEX_Replace([Field1], ".*\\\d+_(\d+)_.*", '$1')

Cheers,

Mark

jannis005

I had not but that worked. From a learning perspective, what is the significance of the \\\ in your regular expression?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703