I ended up needing to just get rid of the www. or https:// and such AND a trailing “/” IF there was one, hope it helps!
LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(URL, "http://",""), "https://",""), "www.", ""),
IF(RIGHT(URL,1)="/",
LEN(SUBSTITUTE(SUBSTIT...
