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!

5 comments

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
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"
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
Muhammad S.
·
·
Let me try to do this one again
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