replace

Syntax: %replace(s,p,r)

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


Contents repeat replaceitem