Replace() function returns a new text in which all occurences of
text are replaced by
Replace(text, old_value, new_value)
A new text where each occurence of
old_value is replaced by
textthe text on which the replace operation is performed.
old_valuethe text that is to be replaced by
new_valuethe text that replaces all occurrences of
Note: Text functions are not case-sensitive and ignore diacritics (accents).
Replace("Apples are round, and apples are juicy.", "apples", "oranges") /* returns "Oranges are round, and oranges are juicy." */ Replace("Dialog", "ial", "") /* returns "Dog" */