Replacer.ReplaceText

Substitute the outdated text with the updated text using the replacer function. This function is compatible with List.ReplaceValue and Table.ReplaceValue.

Syntax

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

About

Substitute the outdated text with the updated text using the replacer function. This function is compatible with List.ReplaceValue and Table.ReplaceValue.

Explanation

Substitute the text "hE" with "He" in the string "hEllo world" using Power Query MReplacer.ReplaceText("hEllo world", "hE", "He") will result in the output "Hello world".