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 DataOutputg;m@gmail.com;test2;test2@aol.comm@gmail.commel2@aol.com;f@hotmail.com;test23@test21.comf@hotmail.comy@youtube.com;t@test21.com;r@test22.comy@youtube.com Reference Column Referencem@gmail.comg@yahoo.cmf@hotmail.comy@youtube.comt@test21.comr@test22.com

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

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

Text Mining

Data Investigation

Accepted answers

BrandonB

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.

Append.yxmd

ShankerV

Hi @markbanlawe

It is possible to achieve the solution in 1 tool.

One way of doing this,

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

RobertOdera

Hi, @markbanlawe

Please see the below.

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

For_markbanlawe.yxzp

All comments

BS_THE_ANALYST

@markbanlawe One way of doing this:

help130223.yxmd

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

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.