regex_replace Function
regex_replace searches a given string for another given substring, and
replaces each occurrence with a given replacement string. The substring
argument can be a valid regular expression or a string.
regex_replace(string, substring, replacement)substring should not be wrapped in forward slashes, it is always treated as a
regular expression. The replacement string can incorporate captured strings
from the input by using an $n or ${n} sequence, where n is the index or
name of a capture group.
Examples
> regex_replace("hello world", "world", "everybody")hello everybody > regex_replace("hello world", "w.*d", "everybody")hello everybody > regex_replace("-ab-axxb-", "a(x*)b", "$1W")--- > regex_replace("-ab-axxb-", "a(x*)b", "${1}W")-W-xxW-Related Functions
replacesearches a given string for another given substring, and replaces all occurrences with a given replacement string.