Regex help extract partial file path

Hello I have the below filenames
P:\Finance\JE Upload Testing\3\01-208-210 IC Debt HPS.xlsx
P:\Finance\JE Upload Testing\21\12-214 RBC HPS payment - AI Dec-21.xlsx
P:\Finance\JE Upload Testing\30\10-07 NWA - CIA Group Hours.xlsx
P:\Finance\JE Upload Testing\31\01-03 Erik Payroll Reclass.xlsx
P:\Finance\JE Upload Testing\32\01-01 UA TB 01-22.xlsx

I need to extract from each:
\3\01-208-210 IC Debt HPS.xlsx
\21\12-214 RBC HPS payment - AI Dec-21.xlsx
\30\10-07 NWA - CIA Group Hours.xlsx
\31\01-03 Erik Payroll Reclass.xlsx
\32\01-01 UA TB 01-22.xlsx

I can’t get the expression right, can someone please help?

thanks so much in advance.

1 Like

Hey @lynnsong986

Please find the below expression,

\\\d*\\.*\.xlsx

Thanks
#nK

@Nithinkrishna thank you so much for your quick response!!

1 Like

Cool @lynnsong986 :slightly_smiling_face:

(?<=Testing).*

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.