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