REPLACE
Returns the resulting string after all instances of a specified substring are replaced with a different substring.
Return Value
String
Syntax
REPLACE( string1, string2, string3 )
where:
- string1 is the main string where the substring to be replaced (string2) is located.
- string2 is the substring to be replaced.
- string3 is the replacement string for string2.
Any of these strings can be referenced using an expression.