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
Solved! Go to Solution.
Did you already try this expression?
REGEX_Replace([Field1], ".*\\\d+_(\d+)_.*", '$1')
Cheers,
Mark
I had not but that worked. From a learning perspective, what is the significance of the \\\ in your regular expression?
Excellent question @jannis005!
I'm glad that you asked.
Very helpful - thanks for the insight!