hi!
i have a file like the attachement.
I'd like to get for each line the min, max and average values. (there is 255 values for each line)
how can i get that ?
i try this, is it right?

BEGIN {FS = ","; OFS = ";";max=0;min=0;moy=0;total=0;freq=890}

$0  !~ /Trace1:/ {
        
        max=min=moy=total=$1
        for (i=2;i<=NF;i++)
            { if ($i>max) {max=$i}
              if ($i<min) {min=$i}
              total=total+$i
            }
        
        print freq,min,max,total/255    
        freq=freq+0,202    
                    
        }
                    
                            
     
END       {}

Attached Files

File_1.zip (1.96 MB, 23 views)

BEGIN {FS = ","; OFS=";"; freq=890}

$0  !~ /Trace1:/ {

   max=min=total=$1
   for (i=2; i <= NF; i++) {
      if ($i > max) max=$i
      if ($i < min) min=$i
      total += $i
   }

   print freq, min, max, total/255

   freq += 0.202
}