SUBSTITUTE
Returns the string after replacing existing text with new text.
Usage examples
-
SUBSTITUTE("abcd", "a", "z", 1) -
SUBSTITUTE(tableA.fieldB, "hello", "world")
Syntax
SUBSTITUTE ( text, search, replace, [ occurence ] )
-
text- any string expression. -
search- any string expression representing the text to search for. -
replace- any string expression representing the text to replace with. -
occurence- any numeric expression representing the instance of matching text to replace. By default, all occurrences are replaced.
Returns
string - the string after replacing matching parts.