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
Transformation job example
SQL
Query result
Last updated