Forum Discussion

FabvE's avatar
FabvE
Icon for Helper I rankHelper 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 ...
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"}))

     

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper 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"}))