Removes all occurrences of a specified substring, and optionally replaces them with another string.
​
​
Syntax
​
​REPLACE(Original String, Substring, New Substring)

​
​Arguments
​
​

Original String:

A custom text string or field in Encompass.
​
​

Substring:

A custom text string that is a single character of pattern or word that you want to remove/replace.
​
​

New Substring:

Optional custom text that will replace the Substring. If this is not specified, the Substring will be removed instead of replaced.

​
Example

REPLACE('ABCD','BC','YZ') = 'AYZD'