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!