Shell Programming and Scripting

sam,22,29,23,24,25,26,22

last_col=7
awk -v L=$last_col  '{sum=0; for(i=3; i<=L; i++) {sum+=$i}; print sum}' infile

# ./justdoit file
please give the your value(s)= test ,   tess121 , unix 12 1999999
sam,22,29,test,tess121,unix,12,1999999,23,24,25,26,22

#!/bin/bash
fix=3;x=1;fs=$(grep -o '[,:;.*|]' $1|sort|uniq)
if [[ $(echo "$fs"|wc -l) -gt 1 ]] ; then
echo "a lot of FS" ; exit 1; fi
read -p "please give the your value(s)= " v
add="$(echo "$v"|sed 's/[0-9A-Za-z][A-Za-z0-9]*[^,]\|[A-Za-z0-9][A-Za-z0-9]*[^,]/&,/g;s/ //g;s/,\+/,/g;s/,$//')"
cut="$(cut -d"$fs" -f$x $1)";(( fix++ ));>new
while [[ ! -z "$cut" ]] ; do (( x++ ))
printf "%s%c" "$cut" "$fs">>new
cut="$(cut -d"$fs" -f$x $1)"
if [ $x -eq $fix ] ; then
printf "%s%c" "$add" "$fs">>new
fi;done<$1;sed 's/'$fs'$\|^'$fs'//g' new

#!/bin/sh
fix=3;x=1;fs=`sed 's/.*\([,:;.*|]\).*/\1/' $1|sort|uniq`
if [ `echo "$fs"|wc -l` -gt 1 ] ; then
echo "a lot of FS" ; exit 1; fi
printf "%s" "please give the your value(s)= " ;read v
add="`echo "$v"|sed 's/[0-9A-Za-z][A-Za-z0-9]*[^'$fs']/&'$fs'/g;s/ //g;s/'$fs'\+/'$fs'/g;s/'$fs'$//'`"
cut="`cut -d"$fs" -f$x $1`";fix=`expr $fix + 1`;>new
while [ ! -z "$cut" ] ; do x=`expr $x + 1`
printf "%s%c" "$cut" "$fs">>new
cut="`cut -d"$fs" -f$x $1`"
if [ $x -eq $fix ] ; then
printf "%s%c" "$add" "$fs">>new
fi;done<$1;
sed 's/'$fs'$//g;s/^'$fs'//g' new

max=$1                                           # set max to the first parameter of the script
IFS=,						 # set the internal field separator to a comma
while read line                                  # process each line
do
  i=0                                            # reset counter
  tot=0                                          # reset total
  for val in $line                               # for each value on the line
  do
    i=$(( i+1 ))                                 # i=i+1
    if [ $i -ge 3 ] && [ $i -le $max ]; then     # if 3 <= i <= max
      tot=$(( tot + val ))                       # add val to tot
    fi
  done
  echo $tot                                      # print total
done < infile                                    # read for file "infile"

oldIFS=$IFS

IFS=$oldIFS