Shell Programming and Scripting

awk ' { sub("[0-9]+$"," &"); arr[$1] = $2 > arr[$1] ? $2 : arr[$1]; cnt[$1]++; }
> END { for ( nm in cnt ) { if( cnt[nm] > 1 ) print nm , arr[nm] , "Count :" cnt[nm] } } ' filename

awk ' { sub("[0-9]+$"," &"); arr[$1] = $2 > arr[$1] ? $2 : arr[$1]; cnt[$1]++; }
> END { for ( nm in cnt ) { if( cnt[nm] > 1 ) print nm , arr[nm] , "Count :" cnt[nm] } } ' filename

$name = $ARGV[0];
$count=0;
$biggest=0;

open (DATA,"<data.txt");

while($line = <DATA>)
{
  chomp;
  if ($line =~ /$name(\d*)/)
  {
    $num = $1;
    $count++;
    $biggest = $num > $biggest?$num:$biggest;
  }
}

print "$ARGV[0]: $count duplicates, biggest is $biggest\n";

awk '
{
   word=$1
   sub(/[a-zA-Z]+/,"",$1)
   num=$1
   sub(/[0-9]+/,"",word) 
   wordcount[word]++
   if  ( user[word] < num ) {
      user[word]=num
   }   
}
END {
    for (usr in user) {
       print usr "->\t" "largest number: " user[usr]
    }
    for (c in wordcount) {
       print c "->\t" wordcount[c],"duplicates"
    }    
}' "file"

 # ./test.sh
mary->  largest number: 10
mike->  largest number:
john->  largest number: 5
alexa-> largest number:
mary->  2 duplicates
mike->  1 duplicates
john->  3 duplicates
alexa-> 1 duplicates