/
REPLACE (search, replace, text)

REPLACE (search, replace, text)

Owned by Alexey Kapitula (Unlicensed)
Last updated: Aug 01, 2017 by Josep Benavent

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

Input Parameters

searchstring or array* of stringThe value being searched for
replacestring or array of string, function**, referenceThe replacement value that replaces found search values
subjectstringThe 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

Related content