Parsing Name from Email Line

[wonka1234]

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

[Felipe_Ribeir0]

-

[ShankerV]

Hi @Felipe_Ribeir0 

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.

[Felipe_Ribeir0 · Accepted solution]

Hi @wonka1234 

One way of doing this

[Felipe_Ribeir0]

Hi @ShankerV 

Its necessary when you realise that your answer was wrong. I am learning so much with you too!

[christine_assaad]

Hi @wonka1234 

This is how I approached it to make sure it works if multiple emails are included. Cheers!

[ShankerV]

Hi @wonka1234 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

@Felipe_Ribeir0 

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---

https://community.alteryx.com/t5/Alteryx-Community-Ideas/Delete-reply-or-post-from-community/idi-p/7...

Many thanks

Shanker V

[flying008]

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.

[EN6924]

One way to do this -