Forum Discussion

FabvE's avatar
FabvE
Helper I
1 year ago
Solved

Table.ReplaceValue with multiple search text

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

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

     

    FabvE 

    maybe you can try this

     

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

     

     

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    1 year ago

     

    FabvE 

    maybe you can try this

     

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