compare two column values

[mikawin]

Hello,

I have three columns with data (shown with space delimiter) that look like:

Col1 Col2 Col3
--------------
x y y=6/x=7
a b a=9/b=4
p q p=6/q=8
r s s=6/r=4

I want to pick the high value for each row and have it output to the 4th column with information as to which Col has the high value. For the above example it would be

Col1 Col2 Col3 Col4
--------------------
x y x=6/y=7 Col2_high
a b a=9/b=4 Col1_high
p q p=6/q=8 Col2_high
r s s=6/r=4 Col2_high

Thanks!
Mika

 

[Annihilannic]

Personally I would use awk for a simple one like that, but perl will serve you equally well. What have you tried so far?

Annihilannic.

 

[mikawin]

Well, I split the Col3 field and first did the number comparison and then compared the letters with the two columns. This works, but it seems too convoluted. Hence the question to the forums.

Thx,
Mika

 

[Annihilannic]

Post your code and then we can offer some constructive criticism.

Annihilannic.

 

[mikawin]

No worries, used a hash and cut the code.

Thx,
Mika