how to select values according to their language？

[Geo-]

I have a column which contains all kinds of language such as French、English、Chinese、Japanese and so on.How to select all French rows or all Chinese rows?

thanks!

[Reeza · Accepted solution]

Is there a way to identify the different languages, or is that essentially what you're asking? A function that will tell you what language a response is in? Assuming this is a survey, that may have been in the original collection information, ie SurveyMonkey has a column that has IP and IP addresses can be mapped back to countries and such. It's not a 100% but probably closer to other options.

[Geo-]

yes,it is a real asking.I am just wondering if there is a way to identify language.I am trying to think another way out