SUBSTITUTE function
This topic describes the formula syntax and usage of the SUBSTITUTE function in the Data Quality Execute Formula transform.
Description
Substitutes new text for old text in a text string.
Syntax
SUBSTITUTE(text, old_text, new_text, [instance_num])