@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***
Posted: 5 months ago
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," ","")