Forum Discussion
Power Query searching for text between 2 columns
Hi all, 2 part question, hopefully pretty simple. I have 2 tables, I'm trying to search a column in 1 table for values in a column on a second table. I want it to return the matched value when ...
Just use List.First instead of Text.Combine (and delete the , ",")
Regards,
Pat
Hi Anonymous
Specify Comparer.OrdinalIgnoreCase in Text.Contains
Text.Contains(myvalue,[Tag]), Comparer.OrdinalIgnoreCase)https://docs.microsoft.com/en-us/powerquery-m/text-contains
Regards
Phil
Perfect thanks everyone