Shell Programming and Scripting

For the data you have pasted, it is working for me. May be you should paste or upload for which it is not working.

--ahamed

Thanks Ahamed,
I uploaded example of the file on dropbox
http://dl.dropbox.com/u/2765863/delta.txt

Code:

root@bt> awk '/TB/{f=$(NF-2);!min?min=f:0;max=f>max?f:max;min=f>min?min:f}END{print max":"min}' infile
110.300:51.130

Not correct?

--ahamed

No, maybe the problem is that I'm on a mac with bash version ?

Code:

GNU bash, version 3.2.48(1)-release (x86_64-apple-darwin11)

Your code may return erroneous min value if the min value is equal to zero .

Example :

Code:

min=0
f=3

!min?min=f ---> this will set min to 3 and will lose the zero value

min=f>min?min:f---> this will then evaluate 3>3? to false ---> min=f=3 ... intead of keeping the zero 0

Thanks for answering guys!

I figured out why I have this problem. In my file there are "." [dots] not "," [commas] between numbers and this was ruining my results.

Code:

BEGIN { max = -1; min = 1000 }
  $4 == "TB" {
    value = $5 ~ /^[[:alpha:]]$/ ? $9 : $8;  
    max = max < value ? value : max;
    min = min > value ? value : min;
  }
  END { printf "max = %.3f\n min = %.3f\n", max, min }

This changed script from @bieri is working for me - I had to change min value because when it was set to -1 the result was -1 as well [there were no smaller values in the file].

Do You have any propositions how I could obtain results without changing all the [dots] to [commas]?

awk -F. ?