Strip out characters using Glide text

[MattLB]

I need to go from this “http://www.careers.northropgrumman.com/” or this “https://www.northropgrumman.com/” to “northropgrumman.com”. I need just the domain name.

I have been looking at Glide compute column for text and can’t figure out how to extract everything between the last / and the second ‘.’ to get the domain name.

Thoughts?? TIA !

[Darren_Murphy]

Use the Extract Matching Text plugin with the following regular expression:

.*\://(?:www.)?([^\/]+)

[kabookie]

Better yet, just use the “Get Part of URL” column type and use the word “host” for the parameter.

[Darren_Murphy]

hah!

I had it in my head that there was already a column for that, but I when I went looking for it I couldn’t find it