https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71436#M24041 Hi.. How to do comparison between two text file.. i am working with 2 target applications one is SAP application second one is wed based application, SAP data is in text format the file is having around 1,76,456 data. web based application data is in Excel Format. if i convert text file to Excel file because of large volume of data it is not converting. if any one having any idea on this please post your comments.. Thanks....  Fri, 22 Mar 2019 21:52:00 GMT NagaYaparla 2019-03-22T21:52:00Z https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71436#M24041 Hi.. How to do comparison between two text file.. i am working with 2 target applications one is SAP application second one is wed based application, SAP data is in text format the file is having around 1,76,456 data. web based application data is in Excel Format. if i convert text file to Excel file because of large volume of data it is not converting. if any one having any idea on this please post your comments.. Thanks....  Fri, 22 Mar 2019 21:52:00 GMT https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71436#M24041 NagaYaparla 2019-03-22T21:52:00Z https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71437#M24042 You can extract data from SAP in Excel format as well right?  Also you can extract text file in Excel columns and then compare two files Mon, 25 Mar 2019 10:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71437#M24042 NarayanShrawagi 2019-03-25T10:30:00Z https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71438#M24043 Yes I can extract SAP data in Excel Format, because of large volume of data Excel is not supporting to generate a report in Excel.     Mon, 25 Mar 2019 16:39:00 GMT https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71438#M24043 NagaYaparla 2019-03-25T16:39:00Z https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71439#M24044 What kind of comparison are you trying to make? Do you just want to be sure it's a 100% match? If so, you can probably use the certutil command via command-line to generate an MD5 hash. Otherwise, would it be possible to load the data into a SQL table temporarily? Mon, 25 Mar 2019 19:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71439#M24044 AmiBarrett 2019-03-25T19:22:00Z https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71440#M24045 @amibarrett, What kind of comparison are you trying to make?--(It's Payroll Process(Employee Information)). Do you just want to be sure it's a 100% match?-- Yes, need to check two reports Data one file is text format, 2nd is Excel Format and the difference between these two file information save it in to Excel Format.   Thanks..! Thu, 28 Mar 2019 20:27:00 GMT https://community.blueprism.com/t5/Product-Forum/Textfile-Comparision/m-p/71440#M24045 NagaYaparla 2019-03-28T20:27:00Z