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)," ")
can this post be deleted as no one seems to have an answer
Hi, doubleclick
List.ReplaceMatchitems is a function manipulate list values.
And you can place the comparer.orignalignorecase function as below:
= Table.AddColumn(#"Renamed Columns", "Custom", each Text.Combine(List.ReplaceMatchingItems({[#"Supplier (cleansed)"]},{{"ltd","Ltd"}},Comparer.OrdinalIgnoreCase)))Plesae check my attached pbix.
Best Regards,
Community Support Team _ Easonthe solution is found here: please can you delete this entire post
= Text.Combine(List.RemoveMatchingItems(Text.Split([#"Supplier (cleansed)"]," "),{"ltd"},Comparer.OrdinalIgnoreCase)," ")
