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!
