Print min and max value from two column

Shell Programming and Scripting
1

Dear All,

I have data like this,

input:

1254          10125
1254          10126
1254          10127
1254          10128
1254          10129
1255          10130
1255          10131
1255          10132
1255          10133
1256          10134
1256          10135
1256          10137
..                 ..
..                 ..
..                 ..

desired output:

1254 = ( 10125 - 10129),
1255 = ( 10130 - 10133),
1255 = ( 10134 - 10137),
..             
..

Thanks for advance,

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}'
1 Like
3

Try

awk     '$1 != tmp1     {
                         if (NR>1) printf "%s),\n", tmp2;
                         printf "%s = (%s -", $1, $2
                        }
         {tmp1=$1; tmp2=$2}
         END {printf "%s),\n", tmp2 }
        ' file
1 Like
4

Solved.. Great RudiC , Thank you.