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.

Retrieving part of URL using RegEx

reignM
7 - Meteor

Hi! I have this example of a data which consist of links.

https://files-example.com/Marie/Abc/03%This%is%40title%20A.mpv 

https://files-abc.com/Marie/Def/04%Video%40title%A.mpv 

https://youtube.com/jdhh92193jkjddvdvp 

https://files-example.com/Marie/Abc/08%Another%40Video%title%A.mpv 

https://files-example.com/Marie/Ghi/08%Title%40Title%title%A.mpv 

https://vimeo.com/dhiwhuwbucdbve 

 

Using RegEx, i wish to get the company name - Abc, Def and Ghi here for those of https://files-example.com files 

 

For example, in this case, bolded is the company name.

https://files-example.com/Marie/Abc/03%This%is%40title%20A.mpv

 

How do i write a regular expression that checks those of https://files-example.com  and retrive that of just the company name in another column? 

 

I am fairly new to RegEx and would absolutely appreciate your help. 

1 REPLY 1
danilang
19 - Altair
19 - Altair

Hi @reignM 

 

This expression appears to do what you're looking for

https\:\/\/files-example.com\/.*?\/(.*?)\/.*

 

danilang_0-1649686381924.png

 

Dan

 

Labels
Top Solution Authors