strip "http:" and ".com" / ".net" from website column

[Dan5]

I have a 'dirty' website column, where some cells have 'https', and some do not. some have 'www', some do not. It is making it difficult to join, due to inconsistencies between sources. how can i for example strip "www.google.com" down to "google", or https://www.ge.com down to 'ge', to make my joins work?

Thanks, 

[jdunkerley79 · Accepted solution]

Try an expression of:

REGEX_Replace([URL], "^(https?://)?(www.)?(.*?)(.com|.net)?$", "$3")

Sample attached

[Dan5]

Thanks for the quick reply! works great!