List.ReplaceValue
Searches a list for the specified value and replaces it.
function (list
as list, optionaloldValue
as nullable any, optionalnewValue
as nullable any,replacer
as function) as list
Searches a list of values,
list
, for the value oldValue
and replaces each occurrence with the replacement value newValue
.List.Transformation functions
Replace all the "a" values in the list {"a", "B", "a", "a"} with "A".
List.ReplaceValue({"a", "B", "a", "a"}, "a", "A", Replacer.ReplaceText)
{"A", "B", "A", "A"}
Last modified 4yr ago