Search Results

Birei sorry for not being clear,

the script work fine.
Perl is new to me so was not able to translate the logic.
but this script works fine for me :)

Thanks Birei for all your effort

It work perfectly for forth column

But it don't catch the difference in 1 to 3 column

for example
file1
pqr|7000|jhon|2.3
xyz|9000|sam|6.7
pqr|8000|kapi|4.5
lmn|3000|kapi|4.6

file 2...

yes
only if it appears in both files

Thanks Birei for Quick response
Yes you are correct

Fourth column is Real number and if its difference is 0.1 or -0.1 it is acceptable so no need to be in output.

If the difference is more...

Hi thanks for your response

1) both the file have different number of line
file1 may have 50 thousand records and file 2 may have 51 thousand record

2) I have to sort the file on the second...

i have two big file which have thousand of line.
i have to sort on two key fields then diff the file.

if the interger value of one of the column is less then or greater then 1 it should ignore...