REPLACE
The REPLACE function replaces an input text string with a given value for a specified index and length. Node references are also accepted as arguments. The index starts at 1 i.e. the first character of the input string will have an index of 1.
Syntax
Arguments
old_string- Required. A text string.
index- Required. A number indicating the position at which the string should be replaced.
length- Required. A number indicating the number of characters to be replaced in the input string.
replace_text- Required. A text string that will replace a part/all of the old_string parameter.
Example
Returns “LUMELRIVER".
Last updated