Applies to: Databricks SQL Databricks Runtime
Replaces all substrings of
str that match
str: A STRING expression to be matched.
regexp: A STRING expression with a matching pattern.
rep: A STRING expression which is the replacement string.
position: A optional integral numeric literal greater than 0, stating where to start matching. The default is 1.
regexp string must be a Java regular expression.
String literals are unescaped. For example, to match
'\abc', a regular expression for regexp can be
Searching starts at
position. The default is 1, which marks the beginning of
position exceeds the character length of
str, the result is