Clay Icon

Guidance Needed for Analyzing Email Domains vs. Company Names

·
·

Hello everyone! I'm working with a table that contains the following columns: Company Name, Phone Number, Email 1, and Email 2. I need to analyze the domains in Email 1 and Email 2 and check if either of these domains matches or is similar to the Company Name. If there's a match, I want to extract that domain and place it into a new column called 'Final Domain.' I'm currently stuck on how to approach this. Could anyone guide me or suggest a solution? Thanks in advance!

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    You can create a new formula column and use this formula

    {{Email 1}}?.split("@")?.[1]?.toLowerCase() === {{Email 2}}?.split("@")?.[1]?.toLowerCase()

    Where Email 1 and Email 2 are your columns containing the two emails Replace these with the actual column names

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    In the attached Screenshot you can see /Email and /E-mail sudreg i want to analyse the domains in both column then want to match the domain with /Nativ poduzeća if the domain is similar to the /Nativ poduzeća name then want to extract the domains and past into /Final Domain from two colmun "Now guide me how this formula work as i already tired"

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    The Nativ poduzeca column contain company names and not domain - The formula solution might not be a good fit here since it checks for the exact match of the domain. I would use Chatgpt here to do this task

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    Let me try to do this one again

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    I think first i need to extract the domains from both email column then i am able to match the domain name with company name