h8rt3rmin8r

Airtable - URL-to-Domain

May 26th, 2019
216
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. IF(SEARCH("://",{url})="","",IF(SEARCH("/",RIGHT({url},(LEN({url})-SEARCH("://",{url})-2)))="",RIGHT({url},(LEN({url})-SEARCH("://",{url})-2)),LEFT(RIGHT({url},(LEN({url})-SEARCH("://",{url})-2)),(SEARCH("/",RIGHT({url},(LEN({url})-SEARCH("://",{url})-2)))-1))))
RAW Paste Data