UNIX for Beginners Questions & Answers

ADD,1,3,5,8,10,11,54
SUB,1,2,3,4
ADD,15,18,21,42,37
ADD,1,1,1,0,0,3,16
ADD,4,1,8,0,4,6,13,16,17,20,8,6,4
SUB,13,8

awk -F',' '{if($1 == "ADD") {for(i=2;i<=NF;i++) t+=$i; print t;} else { t=$2;for(i=3;i<=NF;i++) t-=$i;print t; }t=0}' data.csv

awk -F',' '/^ADD/ {F=1} /^SUB/ {F=-1} {for (i=2; i<=NF; i++) {S+=$i*F; t+=$i*F}; print S; S=0} END {print t}' file
92
-10
133
22
107
-21
323

BEGIN {


}


{


}


END {


}

awk -F',' '
/^ADD/  {F = 1
        }
/^SUB/  {F = -1
        }
        {for (i=2; i<=NF; i++) S += $i*F
         print S
         t += S
         S = 0
        }
END     {print t
        }
' file

BEGIN {   }   {   }   END {   }

begin{
IFS=","
}

{
t=0;
if ($1 == "ADD"){
        for (a=2; a <= NF; a++)
                b += $a;
        else {
                b=$2;
                for (a=3; a <= NF; a++)
                        b=$a)
}
}

end {
printf ("The Sum is: ", b)

}

BEGIN {
  FS=","
}

{
  if ($1 == "ADD") {
    for (a=2; a <= NF; a++)
      b += $a
  }
  else if ($1 == "SUB") {
    for (a=2; a <= NF; a++)
      b -= $a
  }
}

END {
  printf ("The Sum is: %s\n", b)
}

awk -f awkscript infile