Replacer.ReplaceText
Replacer.ReplaceText(text as nullable text, old as text, new as text) as nullable text
Replaces the old
text in the original text
with the new
text. This replacer function can be used in List.ReplaceValue
and Table.ReplaceValue
.
Replace the text "hE" with "He" in the string "hEllo world".
Usage
Replacer.ReplaceText("hEllo world", "hE", "He")
Output
"Hello world"