AWK to compare two files for each field value

Shell Programming and Scripting
1

I have "n" files in directory A and "n" files in directory B. The files are expected to be the same with same data. Each file has 14 columns and "x" rows. Of the 14 column, 2 columns are to be considered as key identifiers. Based on this unique combination, I need to compare each field value between the two files and report the difference.

Note: File in Directory A has values displayed upto 5 decimal places. But file in Directory B has some values displayed as scientific values, some whole numbers and some upto some decimal places.

I am a beginner with Bash and not sure on executing this.

Any help with code would be appreciated.

Thanks!

2

To understand us more, please post sample input and desired output

3

The text file is tab delimited.
Here is the sample file:
File A:
Row1: 6666; D000; $12.00405; $234.08976; $212.09876; the number goes on for another 9 columns
Row2: 6666; D015; $12.56745; $456.34567; $324; 12345;....

File b:
Row1: 6666; D015; $12.56745; $456.34567; $324; 12345;....
Row2: 6666; D000; $12.00405; $234.08976; $212.09876;....

So as you can see, the first two values are the unique row identifier. With that, I need to compare all the other values.

Hope this is clear.

Thanks.

---------- Post updated 07-17-09 at 10:09 AM ---------- Previous update was 07-16-09 at 11:38 AM ----------

Hi people, any help would be appreciated on this.. Thanks!