REPLACE (search, replace, text)

Replaces all occurrences of the search string with the replacement string.

Input Parameters

search	string or array* of string	The value being searched for
replace	string or array of string, function**, reference	The replacement value that replaces found search values
subject	string	The string being searched and replaced on

* an array should be formatted using squared brackets, i.e. ["1", "2"]
** function can be only a GET_VALUE

Execution

on form close (by default)

on form open you need to prefix the formula with an =

Examples

REPLACE("ID1", "Tim", "Hello ID1")
returns: Hello Tim

REPLACE(["ID1","ID2","ID3"], [$1, GET_VALUE ("TASK", "DATA_CODE", "GRAMS"), "potassium"], "ID1 should take ID3 mg of ID2")
returns: Valentina should take 800 mg of potassium