I want to compare excel data with text file

Help Community
,
21

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

22

Send me exact file with same filename for above 3 files

24

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

25

is it resolving?

26

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

27

this is not opening can u send me in zip folder

28

can u send in zip folder its not opening

30

Test1.zip (22 Bytes)

31

folder is empty

32

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

33

@Akash_Javalekar
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)

34

Thank You so much it worked really appreciate

35

@Akash_Javalekar
Pleasure is mine.

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

Happy automation
Happy Learning

Regards,
Gokul Jai

36

like atm id as well as i want to check other details like txn number , txn date and txn amount
system.text.regularexpressions.regex.ismatch(readtext,currentrow(0).tostring.trim+“\s”)
what is \s can you explain this?

37

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

38

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

39

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}")

40

for each text there is different txn date & amount?

41

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}")

42

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