Shell Programming and Scripting

file1.txt        5.38
file2.txt        189.38

cat -vet file2.txt
chr2L^I10^I230^M$
chr2L^I20^I20^M$
chr2L^I35^I1.5^M$
chr2L^I36^I1000^M$
chr3R^I12^I100^M$
chr3R^I20^I300^M$
chrX^I10^I15^M$
chrX^I26^I1500

awk '{print $3}' test.txt | sort -nk1

tr -d '\015' <file1.txt > file1_new.txt
tr -d '\015' <file2.txt > file2_new.txt

file1_new.txt	21.50
file1.txt	21.50
file2_new.txt	1515.00
file2.txt	1515.00

for file in *.txt
do
   gawk -v p=50 '
    {a[sprintf("%07d",$3)]}
    END{
      asorti(a,as)
      end=length(a)
      start=end-int(end*p/100)+1
      if(start>end) start=end
      printf("File has %d unique values, average from %d to %d\n", end, start, end)
      for(i=start;i<=end;i++) total=total + as[i]
      printf "%s\t%.2f\n", FILENAME, total/(end-start+1)}' "$file"
done