Forum Discussion
Power Query - Replace multiple substrings in one column
Hi mwaltercpa,
Please download a demo from the attachment that has a solution of other approaches different from yours.
Just at a glance, your code here may not work the way you need. And I think it's hard to replace in place. So I add a column with the desired result. Finally, you can delete the old column.
Since your actual data isn't clear, I created two possible types. Please refer to the snapshot below.
let index = [Index] in List.First(List.ReplaceMatchingItems(Table.SelectRows(#"Added Index", each [Index] = index)[Column1], {{"TRACY", "TRACI"}, {"MARCY","MARCI"}, {"BARY", "BARI"}}))Text.Combine(List.ReplaceMatchingItems(Text.Split([Column2], ","), {{"TRACY", "TRACI"}, {"MARCY","MARCI"}, {"BARY", "BARI"},{" TRACY", "TRACI"}, {" MARCY","MARCI"}, {" BARY", "BARI"}}), ",")Best Regards,
Dale
Hey Gilbert, thanks for the response. Yes i could do that, however my goal is to use this simple example learn to write M and apply this to more complex requirements. Thanks!
I always suggest using the easiest way to get the job done. There will be times when there might be a more complex requirement. My suggestion is always to keep it as simple as possible and if I can do things via the GUI I do.
Thanks Gilbert, I do have a complex requirment beyond the UI capabilities. I'm keeping this simple for the person that can hlep me work with this. Thanks for your thoughts :)