UNIX for Dummies Questions & Answers

 cat bat.1.enr

name,start,end
bat.1,231, 234

head bat.1

  V1 V2  V3 V4 V5    V6 V7 V8
  0 230 -77 -1  D     xx  0  0
  1 231 -77  0  R      tt  0  0
  2 232 -77  1  T     yy  0  0
  3 233 -76 -1  Y     uu  0  0
  4 234 -76  0  U     re  0  0
  5 235 -76  1  I      dd  0  0

bat.1.out

bat.1
RTYU

#!/bin/ksh
#set -x

while IFS='[, ]' read file start end junk
do
   if ((!c)); then
    ((c=c+1))
    continue
  fi
   awk -v start="$start" -v end="$end" '
     FNR==1 {next}
     $2==start,$2==end {out=(!out)?$5:out $5}
     END { print out > (FILENAME ".out") }
   ' "$file"
done < $(ls *.enr)

 awk -F'[,]' -v q="'" 'FNR==1 {next} {print "awk -v start=" q $2 q " -v end=" q $3 q " -v ext=.out " q "FNR==1{next};$2==int(start),$2==int(end) {out=(!out)?$5:out $5} END{print out > (FILENAME ext)}" q " "$1}' *enr | sh

# dir1 : dir with .enr files
# dir2 : dir with data files
# odir : output dir
[[ ! -d odir ]] && mkdir odir
for f in dir1/*.enr
do
   infile=${f##*/}
   infile="${infile%[.]enr}"
   awk '
   NR==2 { b=$2; e=$3;}
   NR>FNR {$0=" " $0; if (($3>=b) && ($3<=e)) o=o $6;}
   END {of=FILENAME; sub(".*/", "", of) ;  print of; print o}
   ' FS=, "$f" FS="[ \t]*" dir2/"$infile" > odir/"$infile".out
done

for i  in bat\.[0-9]; do awk -F"," 'FNR==NR {for (x=$2;x<=$3;x++)  {val[x]++;file=$1};next}{FS=" ";line[$2]=$5};END{print file;for (x in  line) if (x in val) {printf line[x]}print}' $i.enr $i >>  $i.out;done

awk -F, 'NR>1   {FN=$1;LL=$2;UL=$3;
                 FS=" "
                        while (getline < FN)
                          if ($2>=LL && $2<=UL) printf "%s", $5 > FN".out"
                          printf "\n" > FN".out" 
                 FS=","
                }
        ' *.enr
cat bat.1.out 
RTYU