In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Regex Tool

OEvangelista
7 - Meteor

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

6 REPLIES 6
Felipe_Ribeir0
16 - Nebula

Hi @OEvangelista 

 

You can use this one:

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

 

Felipe_Ribeir0_0-1668116641795.png

 

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

OEvangelista
7 - Meteor

Thanks so much....it works

Felipe_Ribeir0
16 - Nebula

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
21 - Polaris

@OEvangelista One way of doing this

 

binuacs_0-1668122554838.png

 

flying008
15 - Aurora

Hi, @OEvangelista 

 

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

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

flying008_0-1668126712760.png

 

Felipe_Ribeir0
16 - Nebula

Hi @OEvangelista 

 

It worked?

 

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

Labels
Top Solution Authors