Shell Programming and Scripting

#!/bin/sh
#echo "please enter the name of the file you wish to analyse:"
#read filetoint
cd logs/db
ls -l logs/db
cat stats.txt
awk '{sum+=$3}END{print sum/NR}' stats.txt

$ awk '!(T+= $NF) END { print T/NR }' infile
awk: line 1: syntax error at or near END

$ awk '{T+= $NF} END { print T/NR }' infile
1517.5

#!/bin/sh
#echo "please enter the name of the file you wish to analyse:"
#read filetoint
cd logs/db
ls -l logs/db
cat stats.txt
awk '{sum+=$3}END{print sum/NR}' stats.txt

#!/bin/sh

directory=test/logs/etc

cd $directory

FILES="*.txt"

for f in "$FILES"

do

    echo "stats at `date`:"
    echo "slowest response time from db was `cut -f9 -d" " $f | sort -n | tail -1` ms"
    echo "fastest response time from db was `cut -f9 -d" " $f | sort -n | head -1` ms"
    echo "average response time from db was `awk '{sum+=$9}END{print sum/NR}' $f` ms"

#every hour, output to file in format:
#DATE TIME - MIN - MAX - AVG

done

$ 
$ # list all text file in current directory
$ ls -1 *.txt
file1.txt
file2.txt
file3.txt
file4.txt
$ 
$ # show their contents
$ perl -lne 'print $.==1 ? "\n== $ARGV ==\n$_" : $_; close ARGV if eof' *.txt

== file1.txt ==
abcd e544f222e0jk55 1503
abcd e544f222e0jk56 1504
abcd e544f222e0jk57 1505

== file2.txt ==
abcd e544f222e0jk58 1506
abcd e544f222e0jk59 1507
abcd e544f222e0jk60 1508

== file3.txt ==
abcd e544f222e0jk61 1509
abcd e544f222e0jk62 1510
abcd e544f222e0jk63 1511

== file4.txt ==
abcd e544f222e0jk64 1512
abcd e544f222e0jk65 1513
abcd e544f222e0jk66 1514
abcd e544f222e0jk67 1515
$ 
$ # display the contents of the shell script that loops through these
$ # text files and calculates the average of the 3rd field for each
$ # of them
$ 
$ cat -n script1.sh
     1    #!/bin/bash
     2    for f in *.txt; do
     3      avg=$(awk '{sum += $3} END {print sum/NR}' $f)
     4      echo "Average for file: $f = $avg"
     5    done
$ 
$ # run the shell script
$ . script1.sh
Average for file: file1.txt = 1504
Average for file: file2.txt = 1507
Average for file: file3.txt = 1510
Average for file: file4.txt = 1513.5
$ 
$

awk '{T+= $NF} END { print T/NR }' text2