Let’s say if there 5 excels files, you want to check whether there is a japanese word in any of the files. There are 300,000 lines per excel file. Each excel file contains words with many language, eg. English, Chinese. What’s is the fastest way to check whether the excel file contains a word in J…

Fastest way to detect language in file

Deepak94 (Deepak Kolge) November 24, 2019, 6:01pm 6

Hi @Zenith,
You can also try as below.
BoolVar=yourExcelReadDt.contains(“Japanese”)

Thanks!

How to detect there is Chinese Character in a cell in Excel

Topic		Replies	Views
How to detect there is Chinese Character in a cell in Excel Studio studio , question	1	2217	June 29, 2022
How to check if a string is contains english word Activities datatable , excel , uiautomation , orchestrator , activities , studio , question	5	2535	May 22, 2022
Check on (document) language Help	2	1277	June 15, 2018
How to check if an excel file contains a keyword in a particular row(not specified cell) Help excel , activities , question	22	4765	November 16, 2019
Japanese characters - on excel Help Studio datatable , excel , language , language-analysis	3	1198	July 22, 2022