Question
1
Replies
296
Views
Posted: April 29, 2020
Last activity: June 12, 2020
@pxReplaceAllViaRegex function issue
We are using @pxReplaceAllViaRegex function to replace multiple commas with a single comma.
@pxReplaceAllViaRegex(.ToString,"(,)\\1+",",")
Recently we got a production issue where our ToString property holds,
BWN.Assignments@abc.com,joseph.ortego@abc.com,, ,,,kaiwen.jin@abc.com,lauren.balthrop@abc.com
After using this function value is returning like BWN.Assignments@abc.com,joseph.ortego@abc.com, ,kaiwen.jin@abc.com,lauren.balthrop@abc.com
Because of space between 2 commas mails were not sent to kaiwen.jin@abc.com,lauren.balthrop@abc.com user id's.
Any idea to resolve this space issue by using same function?
Thanks
***Edited by Moderator: Pallavi to update platform capability tags***
You can use the replaceAll function to remove the spaces from the output of pxReplaceAllViaRegex.
Please find the below sample syntax to use replaceAll
replaceAll(.Emails," ","")