We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Clean SharePoint People Field Data

charlieepes
7 - Meteor

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

4 REPLIES 4
TimN
13 - Pulsar

Here's one way.

charlieepes
7 - Meteor

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

Does this work for you?

 

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

 

 

Screenshot 2023-11-28 134831.png

Chris

charlieepes
7 - Meteor

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

Labels