Forum Discussion
Solved
Make Text.Replace Case Insensitive
I want to replace any instance of Ltd, whether it's ltd or LTD or Ltd I did a simple right click, replace text and have been experimenting with the comparer.orignalignorecase function but unable ...
the solution is found here: please can you delete this entire post
= Text.Combine(List.RemoveMatchingItems(Text.Split([#"Supplier (cleansed)"]," "),{"ltd"},Comparer.OrdinalIgnoreCase)," ")
= Table.ReplaceValue(#"Renamed Columns", null, null, (x,y,z) => Text.Replace(Text.Upper(x),"LTD",""), {"Supplier (cleansed)"})this is only one variation?
i thought one of you da geniuses could do this easy