We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

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