Import only Non English contained rows and blanks and delete remaining

[Anonymous]

I have an excel sheet as below and i want to import only chines names and blanks into power bi and delete remaining rows.

Excel Sheet data:

-----------------

ID	Name
1	shiv
2	kumar
3	24567
4	谢谢
5	你好
6	明天见
7

Data in Power BI should look like:

---------------------------------------

ID	Name
4	谢谢
5	你好
6	明天见
7

in the given example above i have shown few records but i have millions of rows to do this.

[Zubair_Muhammad]

Hi @Anonymous

Try adding this step in Query Editor

It works with your sample data

= Table.SelectRows(#"Changed Type", each Text.Select([Name],List.Transform({1..126}, each Character.FromNumber(_)))="")

See the attached file

[Zubair_Muhammad · Accepted solution]

@Anonymous

Sorry I had missed the null

File attached as well

try this

= Table.SelectRows(#"Changed Type", each List.ContainsAny({"",null}, {Text.Select([Name],List.Transform({1..126}, each Character.FromNumber(_)))}))

[Anonymous]

Thank you so much @Zubair_Muhammad it worked.

However, i didnt get this trasform List.Transform({1..126) that how it works?. if possible, pls explain.

Thank you again for swift response and help 🙂

[Zubair_Muhammad]

@AnonymousThis function results in a list of majority of characters that we can type from the keyboard

List.Transform({1..126}, each Character.FromNumber(_))

Create a blank query and cope paste above code you will get