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