Comment on page

List.ReplaceMatchingItems

List.ReplaceMatchingItems
Applies each replacement of { old, new }.
function (list as list, replacements as list, optional equationCriteria as nullable any) as list
Description
Performs the given replacements to the list list. A replacement operation replacements consists of a list of two values, the old value and new value, provided in a list. An optional equation criteria value, equationCriteria, can be specified to control equality testing.
Category
List.Transformation functions
Examples
Create a list from {1, 2, 3, 4, 5} replacing the value 5 with -5, and the value 1 with -1.
List.ReplaceMatchingItems({1, 2, 3, 4, 5}, { {5, -5}, {1, -1} })
{-1, 2, 3, 4, -5}

List.Repeat

List.ReplaceRange

Last modified 5yr ago