Search Results

Tryawk '$1 != tmp1 {
if (NR>1) printf "%s),\n", tmp2;
printf "%s = (%s -", $1, $2
}
{tmp1=$1; tmp2=$2}
...

sort -nk2 < file | awk '{if(!x[$1]++){
if(s){print s,p;s=$1" = ( "$2" - "}else{s=$1" = ( "$2" - "}}
else{p=$2"),"}}END{print s,p}'

sed 's/\([^[:alpha:]]*\)\(.*\)/\2 \1/' yourfile

Based on the input given ..

$ nawk '{sub(/[A-Z]/,"\n&")};1' infile | nawk 'ORS=/^[0-9]/?"\n":" "'