I want to compare excel data with text file

These are just samples that i have sent you there is more than 100 ATMID for 100 text files there

Send me exact file with same filename for above 3 files

EJ.zip (30.2 KB)
please find 3 text file

is it resolving?

test1.xaml (14.6 KB)
Try this…Let me know

this is not opening can u send me in zip folder

can u send in zip folder its not opening

Test1.zip (22 Bytes)

folder is empty

please share on my email if possible akashjavalekar02@gmail.com

Kindly find the Zip file which contains Xaml file of the process. Develop the process as much you needed.
Forum_CompareExcelwithTestfile.zip (198.4 KB)

Thank You so much it worked really appreciate

Pleasure is mine.

Kindly mark as a solution. I will helps someone who looking for same issue.

Happy automation
Happy Learning

Gokul Jai

like atm id as well as i want to check other details like txn number , txn date and txn amount
what is \s can you explain this?

@Akash_Javalekar , Used the regex condition to check the ATM ID.

for txn date, txn number & amount what condition should i apply?

Try this

Transaction date: System.Text.RegularExpressions.Regex.Match("SPCNR015 10/11/22 09:15 WDL","\d{2}\/\d{2}\/\d{2}(?=\s\d{2}:\d{2}\sWDL)").tostring.trim

Transaction Amount: System.Text.RegularExpressions.Regex.Match("XXXXXXXXXXXXX8817 4000.00","(?<=XXX\d{4}.*)\d{1,10}.\d{2}")

for each text there is different txn date & amount?

Pass the read text variable

Transaction date: System.Text.RegularExpressions.Regex.Match(Readtext,"\d{2}\/\d{2}\/\d{2}(?=\s\d{2}:\d{2}\sWDL)").tostring.trim

Transaction Amount: System.Text.RegularExpressions.Regex.Match(Readtext,"(?<=XXX\d{4}.*)\d{1,10}.\d{2}")

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.