Pasring column with many emails to names.

Question

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'),'.',' ')

Qiu · Answer

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

0217-wonka1234.yxmd

NikyN · Answer

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

Storing reports in month folders generated dynamically by Alteryx.yxmc