Returns the text being the replacement of all occurrences of the old pattern in the provided text with the new pattern
Attribute of the Plain Text type or string constant or calculation producing text; a regular expression identifying the old pattern and the text indicating the new pattern.
IF REPLACE_PATTERN(Account.Name, 'ohn', 'ack') = 'Jack Smith' THEN ...