Pasring column with many emails to names.

[wonka1234]

Hi,

I have a column named attester.

with emails such as as below in one col.

John.Smith@name.com; Jane.Doe@name.com 

How can I parse these in a formula for a new column to be like:

John Smith, Jane Doe.

Im trying this but only works for 1 name:  ReplaceChar(REGEX_Replace(REGEX_Replace([Attester], ".*<(.+)>.*", "$1"), '(.+)@(.*)', '$1'),'.',' ')

[NikyN]

Hello @wonka1234,

As your regex is working good, I did just work around to make sure that both arguments (all arguments) are parsed.

Record ID is important for Summary tool to group names to the same format as it was.

Let me know if it works for you!

Best Luck!

Niky

[Qiu]

@wonka1234 
I also did not modify your Regex and made a quick sample as below