Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Replacer.ReplaceText
Replacer.ReplaceValue
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
Replacer.ReplaceValue

Replacer.ReplaceValue

Replaces values within the provided input.
function (optional value as nullable any, optional old as nullable any, optional new as nullable any) as nullable any

Description

Replaces the old value in the original value with the new value. This replacer function can be used in List.ReplaceValue and Table.ReplaceValue.

Category

Replacer

Examples

Replace the value 11 with the value 10.
Replacer.ReplaceValue(11, 11, 10)
10
Previous
Replacer.ReplaceText
Next
Splitter
Last modified 3yr ago
Copy link
Outline
Replacer.ReplaceValue
Description
Category
Examples