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".

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

"Hello world"