Hi,

I need help. I have the following input file:

TT,23423.11
YIE,1290.45
SIA,23477.92
...
...

I need a script that will sum up the value from the second column of this file and output a total value.

Thanks

awk -F"," '{col2=col2+$2}
END {printf "Total: %12f\n",col2}' myfile

or to round to two decimal places, use:

printf "Total: %12.2f\n",col2}

The awk solution above is best for what you are trying to do. However, floating point can be done in the shell by piping a string to bc. An example:

#!/bin/sh

IFS=,
string="0"

while read col1 col2
do
if [ col2 != "" ]
then
string="$string+$col2"
fi
done < junk1.dat
echo "scale=2;$string" | bc

The ouput from your data file is:

48191.48