REGEXP_REPLACE
Last updated
Last updated
Replaces every instance of the substring matched by a regular expression pattern in the given string with a specified replacement.
STRING
Type: string
The string that is searched for a PATTERN
match.
PATTERN
Type: string
A regular expression pattern.
This pattern must be a Java regular expression. String literals are unescaped. For example, to match '\abc'
, a regular expression would be '^\\abc$'
.
See the for more information.
REPLACEMENT
Type: string
The string used to replace instances of PATTERN
found in STRING
.
Type: string
STRING
with every instance of the substring matched by the regular expression PATTERN
replaced with REPLACEMENT
.
Hello world
w
W
Hello World
Hello World
o
0
Hell0 World
Bond, James
(\w+)\W+(\w+)
The names $1. $2 $1.
The names Bond. James Bond.
Hello World!
!
''
Hello World
Hello xxWorld
x
''
Hello World
Hellol World
l(?= )
''
Hello World
Hellol World
l(?![lod])
''
Hello World
Helloo World
(?<=o)o
''
Hello World
Hello WorldW
(?<! )W
''
Hello World
null
'(?<! )W
''
null
Mary.Smith3@att.net
att.net
Jordan.Richardson7@hotmail.co.uk
hotmail.co.uk
Jason.Ramirez@aol.com
aol.com
can be referenced in REPLACEMENT
using $g
for a numbered group or ${name}
for a named group. A dollar sign ($
) may be included in the replacement by escaping it with a backslash (\$
):