Hi, I have a Master SS with a column called ‘Full Path’ - along with 3 other columns in this SS I have filtered them and wrote them out into another SS. The next step I need to do is to extract the file name from the end of each of the full paths. e.g Input \home\desktop\joebloggs\banking\Jan\pa…

Extract Parent Path

Gokul001 (Gokul Balaji) December 2, 2022, 9:34am 2

How about this expression

Directory.GetParent("\home\desktop\joebloggs\banking\Jan\payment.pdf")

Regards
Gokul

Topic		Replies	Views
Split operation Studio studio , error	10	897	June 30, 2020
String Manipulation Problem [new DirectoryInfo(Path).Parent] Activities excel , activities , question	10	620	February 12, 2023
Extract the filenames from a folder and save them in Excel or Notepad Studio studio , question , activities_panel	12	2939	September 6, 2023
String Extract Error Studio uiautomation , studio , question , activities_panel , uipath , assign , path	6	948	October 25, 2022
Extract file name from the path Studio studio , question , activities_panel	6	574	April 19, 2023