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)," ")
Greg_Deckler
Community Champion
Community Championdoubleclick Try something like:
= Table.ReplaceValue(
#"Changed Type",
each [Consumer_ID],
each if Text.Contains([Consumer_ID] ), "rick",
Comparer.OrdinalIgnoreCase ) then "Rick" else
[Consumer_ID],
Replacer.ReplaceValue,
{"Consumer_ID"}
)Replace Values in Power Query M (Ultimate Guide) - Gorilla BI
doubleclickNot sure this works.
Say there's 3 entries:
1) Microsoft LTD
2) Google Ltd
3) Amazon ltd
I want the text replace to replace any instance of ltd with nothing, to delete it so i'm only left with the company name