I want to extract domain form Website on Lead Object.
Formula is working for website
http://www.yahoo.com>>yahoo.com
https://www.yahoo.com>>>yahoo.com
but it is not working for website https://www.yahoo.com/help >>> yahoo.com /help
it should extract only yahoo.com
IF(OR(BEGINS( Website, "http://www"),BEGINS(Website, "https://www"), BEGINS(Website, "www.")),
SUBSTITUTE(Website, LEFT(Website, FIND(".", Website)), NULL),
IF(BEGINS(Website, "http://"),
MID(Website, FIND('http://', Website, 1)+7, (LEN(Website) - FIND('http://', Website, 1)+7)),
IF(BEGINS(Website, "https://"),
MID(Website, FIND('https://', Website, 1)+8, (LEN(Website) - FIND('https://', Website, 1)+8)),
IF(BEGINS(Website, "https://") && NOT(CONTAINS(Website,"www.")),
SUBSTITUTE(Website, LEFT(Website, FIND("//", Website)), NULL) ,
Website
)
)
)
)
#Trailhead Challenges #Trailhead#formula #Custom Formula Field #Formulas & Validations
Forum Ambassador Eric Praud (Activ8 Solar Energies)
I checked my formula, and it works for https://www.yahoo.com/help .
However, it does not work if there is no "www." in the website, so try this:
IF(CONTAINS(Website,"www."),
LEFT(SUBSTITUTE(Website, LEFT(Website, FIND(".", Website)), NULL),
IF(CONTAINS(
SUBSTITUTE(Website, LEFT(Website, FIND(".", Website)), NULL),"/"),
FIND("/",SUBSTITUTE(Website, LEFT(Website, FIND(".", Website)), NULL))-1,255)),
IF(AND(NOT(CONTAINS(Website,"www.")),BEGINS(Website,"http")),
MID(Website,FIND(":", Website)+3, FIND("/", SUBSTITUTE(Website,"//","$$"))-FIND(":", Website)-3),
LEFT(Website,
IF(CONTAINS(Website,"/"),FIND("/",Website)-1,255))))
I tested with all your examples and it works every time