[SOLVED] awk, how to find maximum all columns value per row

Basher52 · 10-27-2022, 04:55 PM

I got an awk output showing columns and I need to know the highest value of these columns.
It's easy to do a max on per column on many rows but I need this on all columns per row.

Was thinking of creating an array that I later find the max value of but I can't get that array to work in the next 'pipe'

This is my result in columns and I need the highest value of this which is the best one screen can handle which is different per screen.

Code:

xrandr | awk -F "*" '/*/ { print $0}'
   1920x1080     60.00*+ 144.00   119.98   119.88    99.93    59.94    50.00

I need that 144 which is the frequency one screen can handle.
It's easy to cut out the resolution and the 'trash' but I the highest value that can differ between the screens so I don't know the column of it, thus my problem.

Hope my question is clear enough to understand

//B52

syg00 · 10-27-2022, 07:27 PM

Lose the "-F" - then you'll have access to the normal field number counter. Loop from 2 to NF and check each against current max for that record; computing 101. In awk can be simply done using the ternary operator. Then print $1 (probably) and max.

boughtonp · 10-28-2022, 08:48 AM

What are you trying to achieve here?

Are you sure it cannot be achieved directly with the xrandr command alone?

Basher52 · 10-28-2022, 01:07 PM

Quote:

Originally Posted by boughtonp

What are you trying to achieve here?

Are you sure it cannot be achieved directly with the xrandr command alone?

Have no clue but I think I got it. Did a loop through the columns and got what I wanted so, it's solved.
Here's the code:

Code:

awk '{max=$1;c=1;for(i=2;i<=NF;i++)if($i>max){c=i;max=$i} printf "%.0f in column:%s\n",max, c}' | aw    k '{print $1}'

I left the "in column..." in there even though I don't need it now, but I might later on...

Thx all for the suggestions.

btw, before this I cut out some 'rubbish' in the output, like column 1 and also the '*' and '+' sign.

MadeInGermany · 10-29-2022, 07:02 PM

Most awk versions stop processing trailing * + %
if a number is enforced.
A +0 is the trick

Code:

awk '{max=$1+0;c=1;for(i=2;i<=NF;i++)if($i+0>max){c=i;max=$i+0} printf "%.0f in column:%s\n",max, c}'

Basher52 · 11-04-2022, 02:48 PM

Quote:

Originally Posted by MadeInGermany

Most awk versions stop processing trailing * + %
if a number is enforced.
A +0 is the trick

Code:

awk '{max=$1+0;c=1;for(i=2;i<=NF;i++)if($i+0>max){c=i;max=$i+0} printf "%.0f in column:%s\n",max, c}'

Tried this but it gave me 1920 thus part of the resolution not the highest frequency

MadeInGermany · 11-05-2022, 05:55 PM

Because it starts with column 1.
Let it start with column 2.