REPLACE

Replaces part of a text string with different text based on the position and number of characters you specify.

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

replace(old_string:string, index:number, length:number, replace_text:string)

Arguments

old_string- A text string.Required.

index- A number indicating the position at which the string should be replaced.Required.

length- A number indicating the number of characters to be replaced in the input string.Required.

replace_text- A text string that will replace a part/all of the old_string parameter.Required.

Example

REPLACE('INFORIVER', 1, 4, 'LUMEL')
//Returns “LUMELRIVER"

Replace function

Excel equivalent

Replace