Forum Discussion
doubleclick
Resolver I
Resolver IMake Text.Replace Case Insensitive, should be easy but is not!
Hello everyone! I want to replace any instance of Ltd, whether it's ltd or LTD or Ltd that will appear as part of a string with a nothing. Plus, i have a few other words i want to do this with ...
You can use below formula in a custom column
= Text.Combine(List.RemoveMatchingItems(Text.Split([#"Supplier (cleansed)"]," "),{"ltd"},Comparer.OrdinalIgnoreCase)," ")
mahoneypat
Microsoft Employee
Microsoft EmployeeHere's one way to do it.
In Transform/Format - make the column lower case
With Replace Values - replace " ltd" with ""
In Transform/Format - choose Capitalize Each Word
Pat
doubleclickResolver I
Resolver INo i cannot, it ruins the whole column...
Not sure why this one problem is so difficult for you powerbi geniuses!