return s with all occurrences of p replaced with r
Examples:
#SHOW %replace(abcdabcd,bc,AAA)
displays:
To remove all occurrences of a substring, replace it with a null string "":
displays:
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: