Forum Discussion
Solved
Case insensitive replacement in Power Query
Hi,
This M code replaces old value with new values in the Particulars column
= List.Accumulate({0..List.Count(rename_particulars[Old name])-1},#"Removed line feed",(state,current)=>Table.Replace...
Hii Ashish_Mathur
Power Query text replacements are case-sensitive by default. To make them case-insensitive, we normalize both the source text and lookup values using Text.Upper or Text.Lower, and apply replacements via Table.TransformColumns instead of Replacer.ReplaceText.
Ashish_Mathur Try this "Comparer.OrdinalIgnoreCase" . This particular function ignores case and applies ordinal rules for comparison.
https://learn.microsoft.com/en-us/powerquery-m/comparer-ordinalignorecase
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.