i'm looking for a simple way to compare record of two files that have the same record format; record format example:
- transaction number
- row number
- article item
- qty
- price
the file FILE01 have all the transaction number with their rows, while the FILE02 have olny one transaction with their rows; now, by reanding the FILE02 i need to show/print the records of the transaction found in the file FILE02 that are different from the file FILE01, also show/print records that are present only in the FILE01 or FILE02
thanks in advance
- transaction number
- row number
- article item
- qty
- price
the file FILE01 have all the transaction number with their rows, while the FILE02 have olny one transaction with their rows; now, by reanding the FILE02 i need to show/print the records of the transaction found in the file FILE02 that are different from the file FILE01, also show/print records that are present only in the FILE01 or FILE02
Code:
FILE01 FILE02 trans.nr row Item qty price trans.nr row Item qty price 0100 01 AR01 1 2,33 0100 01 AR01 1 4,55 KO 0100 02 AR10 2 42,33 0100 02 AR10 2 42,33 OK 0100 03 AR10 4 25,33 0100 05 AR10 4 25,33 KO KO 0100 04 AR__ 5 25,33 0100 04 AR__ 5 25,33 OK 0100 06 ARXX 8 25,33 ___ OK
Comment