Replacer functions

 

The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.

Replacer functions are used by other functions in the library to replace a given value in a structure.

FunctionDescription
Replacer.ReplaceTextThis function be provided to List.ReplaceValue or Table.ReplaceValue to do replace of text values in list and table values respectively.
Replacer.ReplaceValueThis function be provided to List.ReplaceValue or Table.ReplaceValue to do replace values in list and table values respectively.
Show: