Zenith
(Zenith)
November 23, 2019, 9:13am
1
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 Japanese for example.
Looking for experts here to give me some advice how to do it at the fastest way.
Do I need to split the file?
I using UiPath for each row, to check but it is too slow.
Thanks.
1 Like
AshwinS2
(Ashwin S)
November 23, 2019, 9:47am
2
Hi @Zenith
Use Directory.GetFiles(folderpath)
then use for each row in DtTable
row(“ColumnName”).ToString.Contins(“Japaneese word”)
Thanks
ashwin S
Zenith
(Zenith)
November 23, 2019, 10:23am
3
It used that it is too slow
Shivaraju
(UipathLearner)
November 23, 2019, 12:40pm
4
@Zenith
Read the Excel one by one by using Directory.GetFiles(FolderPath)
Firstly, read the respective sheet by using “Read Range” Activity and store it in a datatable Variable as dt1.
Then Use OutputDatatable Activity and pass the readrange output (dt1) and store the output in a string variable as str1.
Finally Use If Condition check str1.Contains(“yourWord”) if it is true then it exists.
Zenith
(Zenith)
November 24, 2019, 3:01pm
5
A string variable is enough to store 300k lines?
Deepak94
(Deepak Kolge)
November 24, 2019, 6:01pm
6
Hi @Zenith ,
You can also try as below.
BoolVar=yourExcelReadDt.contains(“Japanese”)
Thanks!
balupad14
(Balamurugan)
November 24, 2019, 6:59pm
7
Hi @Zenith ,
Here is the link to detect the language code and language name for the text.
Hi,
I have developed an activity to detect the language of the text.
[image]
[image]
It works well to detect the below language.
Tamil
Telugu
English
Chinese
Japanese and others
Sample : LanguageDetector.zip (17.6 KB)
Thanks to Mr. Sasvári Tamás to provide a library to develop this activity.
Regards
Balamurugan.S