Shell Programming and Scripting

Hi,

We have a requirement of calculating the AVG, Peak and 2nd Peak (Say Peak2) of a column in a text file. We are able to get Avg and Peak but we are finding difficulty in getting the 2nd Peak. I tried using the AWK but in vainL. Please find the below Script i have written for fetching AVG and Peak.

Code:

#!/usr/bin/bash

Peak=` cat temp.txt | awk '{ if (($1) > max) max = ($1) } END { print max }'`
echo "Peak value of metrics:" $Peak

Avg=`cat temp.txt | awk '{sum+=$6} END { print sum/NR}'`
echo "Avg value is:" $Avg

Code:

bash-3.00$ cat temp.txt
1 S 3 F 4 78
22 F 33 D 6 67
12 W 1 T 15 86

I want to fecth the 2nd Peak fromtemp.txt. We tried using the $Peak as well. But we failed to achieve 2nd Peak for temp.txt.Request you to help on this.

Its a bit urgent

Is this what you're looking for? The following one-liner will print 2nd peak of first column.

Code:

$ awk '{print $1}' temp.txt | sort -nr | sed -n 2p
12

Thanks balajesuri.. Thats really Great stuff!!

Code:

 
perl -lane 'push(@a,$F[0]); END{$b=(sort @a)[-2]; print $b}' input.txt