replace
Syntax: %replace(string,old,new)
Related: %subregex
return string with all occurrences of old replaced with new
Examples:
#SHOW %replace(abcdabcd,bc,AAA)
displays: aAAAdaAAAd
To remove all occurrences of a substring, use a null string "" as the new value:
#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 |