Forum Discussion
Text.Contain in M Query to check if Value Column Contains Consonant
Hello, I need help. I am using a table to create a new column that checks a column named Value for a consonant. If it contains a consonant, the column is true. Otherwise, it is false. The formula w...
Use this
List.ContainsAny(Text.ToList(Text.Lower([Value])), List.Difference({"b".."z"}, {"e", "i", "o", "u"}))
You can use this in a custom column
List.ContainsAny(Text.ToList([Value]), List.Difference({"b".."z"}, {"e", "i", "o", "u"}, Comparer.OrdinalIgnoreCase))
That removes errors, which is excellent, but still created some false positives.
All the false positives are capital letters; they need to be case-insensitive.
Use this
List.ContainsAny(Text.ToList(Text.Lower([Value])), List.Difference({"b".."z"}, {"e", "i", "o", "u"}))