How to compare two TXT files before send it to SQL
- by adopilot
I have to handle TXT dat files which coming from one embed device, My problem is in that device always sending all captured data but I want to take only difrences between two sending and do calculation on them. After calculation I send it to SQL using bulkinsert function. I want to extract data which is different according to first file I got from device. Lats say that device first time device send data like this in some.dat (ASCII) file
0000199991
0000199321
0000132913
0000232318
0000312898
On second calls to get data from device it is going to return all again (previous and next captured records) something like this
0000199991
0000199321
0000132913
0000232318
0000312898
9992129990
8782999022
2323423456
But this time I do want only to calculate and pass trough data added after first insert.
I am trying to make Win Forms app using C# and Visual Studio 2008