Replace

replace replaces part of a string with another string that you specify.

Syntax

Arguments

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

substring

The set of characters in expression that you want to replace. The substring can occur one or more times in expression.

replacement

The string you want to have substituted for substring.

Return type

String

Example

The following example replaces the substring 'and' with 'or'.

The following string is returned.