Table.ReplaceValue

Table.ReplaceValue(table as table, oldValue as any, newValue as any,replacer as function, columnsToSearch as list) as table  

在 table 的指定列中将 oldValue 替换为 newValue。

示例:

在表中将文本 "goodbye" 替换为文本 "world"。

使用情况:

Table.ReplaceValue(Table.FromRecords({[a = 1, b = "hello"], [a = 3, b = "goodbye"]}), "goodbye", "world", Replacer.ReplaceText, {"b"})

输出:

Table.FromRecords({[a = 1, b = "hello"], [a = 3, b = "world"]}, { "a", "b" })

示例:

在表中将文本 "ur" 替换为文本 "or"。

使用情况:

Table.ReplaceValue(Table.FromRecords({[a = 1, b = "hello"], [a = 3, b = "wurld"]}), "ur", "or", Replacer.ReplaceText, {"b"})

输出:

Table.FromRecords({ [a = 1, b = "hello"], 
    [a = 3, b = "world"]}, {
    "a",
    "b"
})