Hi there I have a text file that contains a little over 150000 lines. And, I need to check a keyword against each line. I noticed it takes a million year with a For Each activity. So I am looking for a faster solution. In my opinion the fastest solution is regex but I am not sure how to extract th…

SOLVED: Thanks a lot. A number of great solutions and suggestions were shared here and on my LinkedIn post . At the end, I am resorting to this C# code snippet (thanks to Nived N for sharing it on my LinkedIn post) that solves my problem: arr_lines = System.Text.RegularExpression.Regex.Matches(str…

How to loop over a large text file?

RPA Discussions

balupad14 (Balamurugan) March 14, 2022, 5:55pm 8

Hi @hacback17 ,

Please check this one.

Regards
Balamurugan.S

1 Like

Topic		Replies	Views
Search for a value in a text file , if text is present , pick the matched row and add in another excel file Studio studio , question , activities_panel	7	1524	April 9, 2021
Searching rows of keywords in a scraped text Help	9	1792	December 2, 2018
Search for a specific string in a file - most performant solution wanted Help studio , regex , string , question , data_manipulation	4	735	January 27, 2020
Find a row quickly in a large xlsx Help	1	668	October 3, 2019
Search Keywords in files StudioX orchestrator , robot , activities , studio , studiox , question	8	947	December 7, 2022

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

How to loop over a large text file?

Related Topics