Pull out domain without .com from a URL

Hi guys,

I have a question about a formula regarding a URL. I want to have the domain without all www. etc before the domain and without the .com or whatever.

LEFT(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE({Website URL}, “http://”,""), “https://”,""), “www.”, “”),
IF(
FIND("/",
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE({Website URL}, “http://”,""), “https://”,""), “www.”, “”))=0,
LEN(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE({Website URL}, “http://”,""), “https://”,""), “www.”, “”)),
FIND("/",
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE({Website URL}, “http://”,""), “https://”,""), “www.”, “”))-1))

My script is working on the left side and it gives me the URL: airtable.com, which is my goal. Now I want to delete the .com, what do I need to add?

Thanks in advance!

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.