Replaces one value with another in the specified columns.
function (table as table, optional oldValue as nullable any, optional newValue as nullable any, replacer as function, columnsToSearch as list) as table
Description
Replaces oldValue with newValue in the specified columns of the table.
Category
Table.Transformation
Examples
Replace the text "goodbye" with the text "world" in the table.
1
Table.ReplaceValue(Table.FromRecords({[a = 1, b = "hello"], [a = 3, b = "goodbye"]}), "goodbye", "world", Replacer.ReplaceText, {"b"})
Copied!
Table.FromRecords({[a = 1, b = "hello"], [a = 3, b = "world"]}, { "a", "b" })
Replace the text "ur" with the text "or" in the table.
1
Table.ReplaceValue(Table.FromRecords({[a = 1, b = "hello"], [a = 3, b = "wurld"]}), "ur", "or", Replacer.ReplaceText, {"b"})
Copied!
Table.FromRecords({ [a = 1, b = "hello"], [a = 3, b = "world"]}, { "a", "b" })