Extracting Subdomains of a list of URLS

[Lazzanova]

Hey guys,

I've got a list of different URLS and I need to extract the subdomain of each of the URL.

A subdomain would be anything between the third and fourth "/" character.

Example URLS:
1) https://www.community.alteryx.com/t5/forums/postpage/board-id/designer-discussions
2) https://www.lovealteryx.com/community/why-i-love-alteryx


In this example the subdomain output should be
1) t5
2) community

I'm guessing I need to use regex for this, but don't know how.

Anyone who can help me out?

With kind regards,

Lazzanova

[cmcclellan · Accepted solution]

See attached, I just used text manipulation to do the same thing.