Table.ReplaceValue with multiple search text

[FabvE]

Hi,

I need some help with the Table.ReplaceValue function.

In my column  need to replace two different values with the same string. So "]" and "[" need to be replaced with "|".

I want to avoid two separate Replace functions but was unable to find a handy solution for this.

Do you have any tips?

Thanky in advance

[ryan_mayu · Accepted solution]

@FabvE 

maybe you can try this

= List.Accumulate({{"[","|"},{"]","|"}},Source,(x,y)=>Table.ReplaceValue(x,y{0},y{1},Text.Replace,{"Column1"}))