REPLACESTRING function

Synopsis
This function replaces all occurrences of one string with another string.
Variations
REPLACESTRING(SourceString, OldString, NewString)
Returns the original string with all occurrences of a specified string replaced with a new string.
Details | Examples | Details and examples
Parameters
SourceString

Specifies the string to find and replace within.

Supported types: String.
OldString

Specifies the string to search for, to be replaced.

Supported types: String.
NewString

Specifies the string to replace OldString with.

Supported types: Numeric.
Returns
Returned types: String.
Examples
1.

The following example replaces "oo" with "ou" to return "Mouse" instead of the original "Moose".

  • sourceString = "Moose"

  • oldString = "oo"

  • newString = "ou"

REPLACESTRING(sourceString, oldString, newString)