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"