Hi,
How can I parse this column from:
Name |
Louis Stevens <Louis.Stevens@hotmail.com>; Ren Stevens <Ren.Stevens@hotmail.com> |
to:
Name |
Louis.Stevens@hotmail.com; Ren.Stevens@hotmail.com |
Solved! Go to Solution.
-
Good trick learned from you Felipe. We can edit the reply when ever we need.
Thanks for the contribution to the community. I read all your replies and those are very helpful.
Hi @ShankerV
Its necessary when you realise that your answer was wrong. I am learning so much with you too!
Hi @wonka1234
This is how I approached it to make sure it works if multiple emails are included. Cheers!
Found this information now, thought of sharing to you also.
---Quote---
Thanks for the feedback! You actually do have the ability to edit your own post up to 48 hours after you've posted.
---Unquote---
Many thanks
Shanker V
Hi, @wonka1234
There is a lively way to get your all mailbox,
1- RegEx to extract all mail address in < >.
(?<=<)[\w.@]+?(?=>)
2- Formula to added ";" between mailbox.
REGEX_Replace([Name], "(@[a-z]+?.com)(?=[[:alpha:]])", "$1;")
3- If you have many people's email in a line, it will can excellence process mission.
******
If it can help you get your want output, please mark it as s solution and give a like for share more.
One way to do this -