h8rt3rmin8r

Airtable - URL-to-TLD

May 27th, 2019
206
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. IF(IF(SUBSTITUTE(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)))),".","")>=0,"",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)))))="","",RIGHT(IF(SUBSTITUTE(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)))),".","")>=0,"",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))))),(LEN(IF(SUBSTITUTE(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)))),".","")>=0,"",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))))))-SEARCH("\\/\\/",SUBSTITUTE(IF(SUBSTITUTE(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)))),".","")>=0,"",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))))),".","\\/\\/",(((LEN(SUBSTITUTE(IF(SUBSTITUTE(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)))),".","")>=0,"",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))))),"."," "))-LEN(SUBSTITUTE(SUBSTITUTE(IF(SUBSTITUTE(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)))),".","")>=0,"",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))))),"."," ")," ","")))/LEN(" "))+0))))))
RAW Paste Data