REPLACE
Replaces or removes a substring within the given string.
Syntax
Arguments
STRING
STRING
Type: string
The string to search.
SEARCH
SEARCH
Type: string
The substring to search for in STRING
.
If this is an empty string, then REPLACE
is inserted in front of every character and at the end of the STRING
.
REPLACE
REPLACE
Type: string
Default: ''
(Optional) The string used to replace all found instances of SEARCH
.
If omitted, all instances of SEARCH
are removed from STRING
.
Returns
Type: string
A substring of the input STRING
.
Examples
STRING
SEARCH
REPLACE
Output
string
g
strin
a
a
''
a
a
b
b
123
1
23
word
word
bird
bird
word
bird
thing
word
word
or
wd
word
null
null
null
bird
null
Transformation job example
SQL
Query result
customer_email
remove_gmail
Gerald.Morgan@gmail.com
Gerald.Morgan
Teresa.Reed@gmail.com
Teresa.Reed
Larry.Torres@yahoo.com
Larry.Torres@yahoo.com
Last updated