Skip to main content

List.ReplaceValue

Searches a list for the specified value and replaces it.

Syntax

List.ReplaceValue(
list as list,
oldValue as any,
newValue as any,
replacer as function
) as list

Remarks

Searches a list of values, list, for the value oldValue and replaces each occurrence with the replacement value newValue.

Examples

Example #1

Replace all the "a" values in the list {"a", "B", "a", "a"} with "A".

List.ReplaceValue({"a", "B", "a", "a"}, "a", "A", Replacer.ReplaceText)

Result:

{"A", "B", "A", "A"}

Category

List.Transformation functions