Replacer.ReplaceText

Syntax

Replacer.ReplaceText(
    text as nullable text,
    old as text,
    new as text
) as nullable text

About

Replaces the old text in the original text with the new text. This replacer function can be used in List.ReplaceValue and Table.ReplaceValue.

Example 1

Replace the text "hE" with "He" in the string "hEllo world".

Usage

Replacer.ReplaceText("hEllo world", "hE", "He")

Output

"Hello world"