String manipulation

REPLACE – Search for and replace text

72 views June 1, 2018 admin 0

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.

See also

FIELDSTR

REMOVEBLANKLINES

REMOVEDUPLICATES

Was this helpful?