Extracting Sheet Name and File Name from the full path

[SH_94]

Dear community,

I would like to ask how can we get the file name and sheetname from the screenshot below:

Many thanks for the help.

[Qiu · Accepted solution]

@SH_94 
We can use RegEx to do it.

[SH_94]

Hi @Qiu ,

Many thanks for the prompt response.

May i know if there is formula to eliminate the file name extension within the regex? for example, remove the extension - .xlsx from the filename?

Thank you.

[Qiu]

@SH_94 
We can just move the ".xlsx" out of the brackets.