awk how I could print only the largest value per record?

Question

I have a input like this ; i need to filter the greater record value

cat;5
dog;3
bird;2
cat;3
dog;6
bird;8

for output a result like this

cat;5
dog;6
bird;8

Find the smallest numbers in the second column corresponding to index values in first column - you can easily adapt any of the answers there to print the max instead of the min... — don_crissti
– don_crissti, Commented Mar 15, 2017 at 15:13

NarūnasK · Accepted Answer · 2017-03-15 15:40:44Z

1

Please try the following:

#!/usr/bin/awk -f

BEGIN {
  FS = OFS = ";";
}

{
  if($2 > a[$1]) { a[$1] = $2 }
  else { a[$1] = $2 }
}

END {
  for(x in a) { print x, a[x] }
}

answered Mar 15, 2017 at 15:19

NarūnasK

2,5555 gold badges28 silver badges38 bronze badges

1 Answer 1