regexp_replace(string, pattern, value)

Replace all occurrences of a regular expression pattern with the specified value. The value string can contain a back reference to a value captured with the regular expression pattern. For example %1 is the first value capture, %2 is the second, etc. Two consecutive % characters must be used in the value string to represent the % character.

Examples

str = regexp_replace("The quick brown", "[aeiou]", "" )
str = regexp_replace("foobar", "(...)(...)", "%2%1d" )