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)," ")
Hi doubleclick ,
Please try below approach.
https://www.youtube.com/watch?v=-oM83cgs5uI
Thanks,
Samarth
I watched this already - can someone help with the code?