Testing a String if it Contains a string from a reference column

[markbanlawe]

Good day,

How do we parse through a string of email address and identify that one of the email addresses would be in a list?

Sample Data

Data	Output
g;m@gmail.com;test2;test2@aol.com	m@gmail.com
mel2@aol.com;f@hotmail.com;test23@test21.com	f@hotmail.com
y@youtube.com;t@test21.com;r@test22.com	y@youtube.com

Reference Column

Reference

m@gmail.com

g@yahoo.cm

f@hotmail.com

y@youtube.com

t@test21.com

r@test22.com

[BS_THE_ANALYST]

@markbanlawe One way of doing this:

[ChrisTX]

Use a Text-to-Column tool, split to Rows, using Delimiter = semi-colon

Then use a Join tool, and join to your Reference column.

Chris

[BrandonB · Accepted solution]

I believe that the "Find Replace" tool will work perfectly for this using the "Any Part of Field" option selected as well as Case Insensitive Find box checked potentially. 

[ShankerV · Accepted solution]

Hi @markbanlawe 

It is possible to achieve the solution in 1 tool.

One way of doing this,

[RobertOdera · Accepted solution]

Hi, @markbanlawe 

Please see the below.

Please mark it as an acceptable solution if it works for you. Cheers.

[markbanlawe]

thank you for the suggestion 

[markbanlawe]

@BS_THE_ANALYST  the last row of  the output did not match the needed item

[BS_THE_ANALYST]

@markbanlawe correct! My solution shows you every e-mail from the Sample Data that is featured in the Reference Column. 

[RobertOdera]

@markbanlawe 

You are most welcome - cheers!