Dear friends,

I have two files. In first file first column ($1), i have numbers.

The second file containes, the same number in the fourth column($4).

I need a output file, matching the first file column 1 with second file column 4. The main thing is the output file lines will be sorted without changing the line.


Eg:

File1:
123
124
125

File 2:

we are at 123 from unix
we are at 124 from linux
we are at 123 at script
we are at 567 at perl
we are at 125 at awk

Desired Output:
we are at 123 from unix
we are at 123 at script
we are at 124 from linux
we are at 125 at awk

If the number is always in the fourth column and all you need is to sort numerically, you don't need Perl at all.

sort -rn -k4 file2

Hi thanks,

But my question is not like sorting.

I am explaining little detaily:

FIle 1:

123 678 345 hi 6798
452 789 256 bi 8746
145 689 124 ji 435
456 690 345 ki 789

File 2:
345
256
124

Expected Output:

The outfile should rearrange according to the fourth column of file1, matching with the first column of file2.

Like:

123 678 345 hi 6798
456 690 345 ki 789
452 789 256 bi 8746
145 689 124 ji 435

Then the column 5 should be added for 345 matching individuallly, 256 invidually, 124 individually.

Like:
the addition of 345 match 5th column is 6798+789 = 7587
the addition of 256 macth 5th column is 8746
the addition of 124 match 5th column is 435

Thanks in advance for your reply,
Vasanth

This question is asked a lot here, although the answer is usually in awk. Search for NR==FNR and throw in Perl to see how it's done in Perl.

http://www.unix.com/cfmgoogle.php?cx...sa=Search#1061

I have closed the poll. I see no purpose it serves.

bakunin