Skip to main content

I want to extract domain form Website on Lead Object.

Formula is working for  website 

www.yahoo.com>>>yahoo.com

yahoo.com>>yahoo.com

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

8 件の回答
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    2022年2月14日 12:07

    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

0/9000