replaces all occurrences of the specified pattern in the text with a new pattern.
REPLACE_PATTERN2 (text, old, new)
attribute of Plain Text type or expression producing Plain Text, the pattern to be replaced and the pattern to replace with.
Text: the text with every occurrence of old replaced by new, matched as plain text (not a regular expression; use REPLACE_PATTERN for that)
REPLACE_PATTERN2 ('John Smith', 'Smith', 'Black')
returns 'John Black'