Remove non-english rows from the table.

[TheeWoko]

Need all non-English rows removed. 

This an excerpt of the entire table, there are over 300 rows.

[SamWiseOwl · Accepted solution]

Step 2 click the column with the language, untick Select all and tick english:

[SamWiseOwl]

Have you tried the Text Analytics option in the Query editor? Can detect 120 different languages.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-ai-insights

[TheeWoko]

I'm not trying to identify them, I'm trying to remove them 😂

Trying to clean the data and optimise it for english-speaking clients so need only english apps.

[SamWiseOwl · Accepted solution]

Step 2 click the column with the language, untick Select all and tick english:

[TheeWoko]

Thank you a lot, worked great but left some foreign apps tht have english words. FAR FAR better than what we had. Thank you!

[SamWiseOwl · Accepted solution]

Hi @TheeWoko 

In the query editor choose Add Column | Custom Column then paste this code in replacing App with what ever your column is called:

if List.Contains({"a".."z","0".."9"," ", ".", ",", "'", "!", "?"}, Text.Lower(Text.Start([App], 1))) and List.Contains({"a".."z","0".."9"," ", ".", ",", "'", "!", "?"}, Text.Lower(Text.End([App], 1))) then "English" else null

This will test if the first and last letters are in the comma seperated list, feel free to add as many other punctuation marks as you like to both lists.

Attached file as example.

[SamWiseOwl]

I'm trying another approach using M.
Taking the first and last letters then checking they are both "English".

A better test would be checking if they aren't english but there are something like 330k Unicode characters that makes it ... impractical to test.