Regex Tool

[OEvangelista]

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

[Felipe_Ribeir0]

Hi @OEvangelista 

You can use this one:

(?<=E\:\\)(.*?)(?=\\)

It is basically parsing everything between E\: and the next \

[OEvangelista]

Thanks so much....it works

[Felipe_Ribeir0]

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!

[binuacs]

@OEvangelista One way of doing this

[flying008]

Hi, @OEvangelista 

Dear, the other way don't need regex for your case:

Substring([Path],FindString([Path], "\")+1,FindString(ReplaceFirst([Path], "\", "?"), "\")-(FindString([Path], "\")+1))

[Felipe_Ribeir0]

Hi @OEvangelista 

It worked?

If yes, please accept the answer as a solution :) Thanks