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.