Replace All function
We are using Replace All function for a string specified like below which varies dynamically based on cases.
[email protected],[email protected],,[email protected],,,[email protected],[email protected]
Currently we are using function like below but its getting failed if pyToString has commas more than 2.
@replaceAll(.pyToString,",,",",")
Is there any function to check pyToString value greater than a single comma by using replace all function.
Any suggestions on this issue pls.
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
We can replace more than 2 commas with single comma using pxReplaceAllViaRegex
Please find the sample expression below:
@pxReplaceAllViaRegex(Param.String,",{2,}" ,",")
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
It is a regular expression, it checks if the comma is repeated at least twice in the above scenario.
Please find another example below.
IQZ Systems
IN
Hi
Use @pxReplaceAllViaRegex(.pyToString,"(,)\\1+",",")
I have tried using above example @pxReplaceAllViaRegex(" Proprietary information hidden, Proprietary information hidden,, Proprietary information hidden,,, Proprietary information hidden, Proprietary information hidden","(,)\\1+",",")
and it is working fine.
Thanks
IQZ Systems
IN
Hi
"(,)\\1+" is a regular expression. The char , in brackets is the character to match and after \\ (double slash) states the number of repetitions. 1+ defines more than once.
Hope this helps