Shell Programming and Scripting

# cat marks.txt
        MARKS LIST
               2013
Name english french chinese latin total_marks
wer        34    45     67      23
wqa       12      39     10      56
wsy       23      90     23      78

#!/usr/bin/ksh
set -x
TotalLines=`cat marks.txt | wc -l`
Line=4
while [ $Line -le $TotalLines ] &&  read LINE
do
we=`awk '{print $2 $3 $4 $5}' | grep '[0-9]' | awk '{sum+=$1} END {print sum}'`
Line=$((Line+1))
echo $we
done < marks.txt

# ./marks.sh
+ + wc -l
+ cat marks.txt
TotalLines=       6
+ Line=4
+ 0< marks.txt
+ [ 4 -le 6 ]
+ read LINE
+ + awk {print $2 $3 $4 $5}
+ grep [0-9]
+ awk {sum+=$1} END {print sum}
we=70750157
+ Line=5
+ echo 70750157
70750157
+ [ 5 -le 6 ]
+ read LINE

awk '{sum+=$1} END {print sum}'

$ cat marks.txt
        MARKS LIST
               2013
Name english french chinese latin total_marks
wer        34    45     67      23
wqa       12      39     10      56
wsy       23      90     23      78

$ awk 'NF == 5 {sum = $2 + $3 + $4 + $5; print $0, sum } NF != 5 {print}' marks.txt
        MARKS LIST
               2013
Name english french chinese latin total_marks
wer        34    45     67      23 169
wqa       12      39     10      56 117
wsy       23      90     23      78 214

NF == 5 # if five fields on the line (wer, wqa, and wsy lines)
  {
  sum = $2 + $3 + $4 + $5; # get sum by adding fields 2 through 5
  print $0, sum # print entire input line followed by the sum
  } 
NF != 5 # if not five fields on the line (other lines)
  {
  print # just print the entire line
  }

awk 'NF == 5 {sum = $2 + $3 + $4 + $5; print $0, sum; next } 1' marks.txt

awk 'NF == 5 {print $0, $2 + $3 + $4 + $5; next } 1' marks.txt