Reference material for REPLACE function
<pattern>
substring within the <expression>
with the <replacement>
substring.
Parameter | Description | Supported input types |
---|---|---|
<expression> | The original string that will be searched for instances of the <pattern> . | TEXT |
<pattern> | The substring to be searched and replaced in the string. | TEXT |
<replacement> | The substring to replace the original substring defined by <pattern> . To remove the <pattern> substring with no replacement, you can use a empty string '' as the replacement value. | TEXT |
Level three
In this example below, “eight” is replaced by an empty string.
Level
In this following example, the substring “five” is not found in the original string, so the string is returned unchanged.
Level four