Strings / replace

replace(string, string, string)

Finds all occurrences of a substring inside of a source string, and replaces them with the replacement string. The first argument is the source, the second is the search string, and the third is the replacement.

replace("XYZ", "Y", "and")

...returns "XandZ"

replace("bob and mary went to bob's house", "bob", "judith")

...returns "judith and mary went to judith's house"