Free Trial

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