replace
Syntax: %replace(s,p,r)
Related: %subregex
return s with all occurrences of p replaced with r
Examples:
#SHOW %replace(abcdabcd,bc,AAA)
displays:
aAAAdaAAAd
To remove all occurrences of a substring, replace it with a null string "":
#SHOW %replace(abcdabcd,bc,"")
displays:
adad
or, just leave out the third argument: %replace(abcdabcd,bc)
#VAR priceList {986|4237|4619|4627|3918|3627|9764|298}
#SHOW %max(%replace(@priceList,"|",","))
displays:
9764
|