Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Textfile Comparision

NagaYaparla
Level 4

‎22-03-19 09:52 PM

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.... 
0 Likes
4 REPLIES 4

NarayanShrawagi
Level 6

‎25-03-19 10:30 AM

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
Narayan
0 Likes

NagaYaparla
Level 4

‎25-03-19 04:39 PM

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.    
0 Likes

AmiBarrett
Level 12

‎25-03-19 07:22 PM

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?
0 Likes

NagaYaparla
Level 4

‎28-03-19 08:27 PM

@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..!
0 Likes