Replace

The Replace() function returns a new text in which all occurences of old_value in text are replaced by new_value.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text where each occurence of old_value is replaced by new_value. Returns Invalid expression if the result is not a text.

Syntax

Replace(text, old_value, new_value)

Replace("All the 1234 parts will be replaced.", "the 1234", "unknown or illegal") => "All unknown or illegal parts will be replaced."

Parameters

Name	Type	Required	Description
text	text	☑️	the text on which the replace operation is performed.
old_value	text	☑️	the text that is to be replaced by new_value.
new_value	text	☑️	the text that replaces all occurrences of old_value.