UNIX for Dummies Questions & Answers

Hi guys,

I already search on the forum but i can't solve this on my own.

I have a lot of files like this:

And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in column 2.

So the output should be:
I already can get the line based in the maximum value of last column with this awk:

Code:

awk '{if ($3 > max) max=$3} END {print line=$0}'

That give me this:
But now i don't know how to get the "cluster 7 ligands 2" and not the "cluster 9 ligands 2". I was thinking in get the minimum value in 2 column in case of the maximum value repeats but i can't find how to do that

Thanks for any help

That script always prints the last line (and in some awks it prints an empty line). Try:

Code:

awk '{if ($4 > max) {max=$4; maxline=$0}} END {print maxline}' infile

This works is the clusters are in sorted order, otherwise you will need to test for $2 too.

Yes this solve the problem, and in all files the clusters are in order.

If you can you confirm this to me.

For what i can tell my mistake was the

Code:

{print line=$0}

in my awk that give always last line and not the one with max value right?

Sorry if is a dumb question but im new in script

Hi, yes this line is in the END section, which gets executed after the input file(s) will have been read. The statement means set variable "line" to the last record ($0) and prints the result.. On some awks $0 will still contain the last record, but this is not guaranteed, so it may print an empty line. Anyway, if written like that it would be equivalent to:

Code:

awk 'END {print}'

Hum ok thanks again

---------- Post updated at 04:18 AM ---------- Previous update was at 04:17 AM ----------

Hum ok thanks again.


This is solved you can close