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 |
Solved! Go to Solution.
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
Hi, @markbanlawe
Please see the below.
Please mark it as an acceptable solution if it works for you. Cheers.
thank you for the suggestion
@BS_THE_ANALYST the last row of the output did not match the needed item
@markbanlawe correct! My solution shows you every e-mail from the Sample Data that is featured in the Reference Column.
You are most welcome - cheers!