Compare

[aparna0208]

Hi,

Need some help with the below logic. Thanks in advance!

I have a dataset which includes email address and firm name as seen below. I want to validate the emails to see if the person has moved firm. I am thinking to exclude the ones before "@" symbol and only extract the domain(eg: abc.com, xyz.com) and compare it to the firm name to see if it aligns with it and return true or false.

For example: 

Email                                        Firm                             New col

j.will@abc.com                          ABC corp                    TRUE

y.smith@xyz.com                      Ed jones                      FALSE

[MichaelSu · Accepted solution]

Hi @aparna0208,

Please see attached workflow. You can leverage the text to columns to split the data up and the contains statement to see if the domain ties to the company name.

Thanks,

Mike

[atcodedog05 · Accepted solution]

Hi @aparna0208 

Here is my take on the use case.

Workflow:

1. Using regex formula to extract company between @ and .com (note if .com changes to .biz or any extension it will still work)

2. Using contains (note contains is caseinsentive abc is same as ABC) formula to check if email company is in actual company if yes flag.

Hope this helps 🙂