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.
| Function | Description |
|---|---|
| Replacer.ReplaceText | This function be provided to List.ReplaceValue or Table.ReplaceValue to do replace of text values in list and table values respectively. |
| Replacer.ReplaceValue | This function be provided to List.ReplaceValue or Table.ReplaceValue to do replace values in list and table values respectively. |
Show: