Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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