Table of Contents
Overview
This Custom Field performs a simple search-and-replace operation on a string.
Syntax
REPLACE(SourceString, ‘SearchText’, ‘ReplaceText’)
REPLACE(FIELDSTR(Description), ‘AAA’, ‘BBB’)
| Element | Description |
|---|---|
| SourceString | String to search in. |
| SearchText | The text to search for. |
| ReplaceText | The text to replace the found text. |
Example
REPLACE(FIELDSTR(Description), ‘fantastic‘, ‘good‘)
| Description | REPLACE(FIELDSTR(Description), ‘fantastic‘, ‘good‘) |
| All Ford motor cars are fantastic. | All Ford motor cars are good. |
| Toyotas are not so fantastic. | Toyotas are not so good. |