Clean SharePoint People Field Data

[charlieepes]

Hi:

I am trying to clean the multi-person person field data output from a SharePoint List. 

My Regex works part-way but it stops before removing the end characters.
Note that there should not be any characters at the end.  I'd appreciate your help.

Thanks-

Before:   mary.mason@mycompany.com;#3206;#michael.smith@mycompany.com;#3212;#peter.jones@mycompany.com;#3213

My Attempt:   REGEX_Replace([Field1], "(\W\d+\W+)", " ")

Result:   mary.mason@mycompany.com; michael.smith@mycompany.com; peter.jones@mycompany.com;#3213

Desired Result:   mary.mason@mycompany.com; michael.smith@mycompany.com; peter.jones@mycompany.com

[TimN · Accepted solution]

Here's one way.

[charlieepes]

Thank you@TimN
I can work with this. I need a single cell with all email addresses separated by a semi-colon, but I can go from here.  Thank you! 

[ChrisTX · Accepted solution]

Does this work for you?

TrimRight(Trim(REGEX_Replace([F1], "(.*?;)#\d*;*#*", "$1 ")),";")

 

Chris

[charlieepes · Accepted solution]

@ChrisTX That's exactly what I was looking for!  Thank you.  Very concise!