Hi - I am pretty new to Regex and I want to extract the word "Title" from below. Can someone please advise if I use the Regex tool, what do I put in the Regular Expression field if I just want to parse "Title"?
FullPath
E:\Title\SANDBOX\Below \Scotch Tape.zip
E:\Title\SANDBOX\Below PPPPP (2022-05-31).zip
E:\Title\SANDBOX\AAA\\ScotchTapes\ABL_\ScotchTape_20210803.xxx.yyy.zzz
E:\Title\SANDBOX\AAA\DailyReports\PostLoanSaleReports\PrePost_HolidaySales_bgtsd_20210910_144245.xlsx
Thank you
You can use this one:
(?<=E\:\\)(.*?)(?=\\)
It is basically parsing everything between E\: and the next \
Thanks so much....it works
Hi @OEvangelista , i am glad to hear that :)
If you could accept my answer as a solution to mark this topic as solved, i would appreciate.
Thanks!
Hi, @OEvangelista
Dear, the other way don't need regex for your case:
Substring([Path],FindString([Path], "\")+1,FindString(ReplaceFirst([Path], "\", "?"), "\")-(FindString([Path], "\")+1))