I have file
"1","x1897"," 89.10"
"1","x2232"," -12.12"
"1","x1897"," 389.10"
"1","x2232"," 212.12"
"1","x1897"," 19.10"
"1","x2232"," 2.12"


i want to add all 3 rd column rows (they have spaces also)for x1
and sum of 3rd column rows for x2 separately.
I am very bad at awk. can some one help me ?

What have you tried so far?

This is not homework for a class is it???

or with a new line in between

If the file has more than three fields, use ...

this is not homework problem..

this is what i did

while read file
do
var=`echo $file | cut -f 3 -d "," | sed
....
....
done < file

but i donot wantt to use while loops


-------------------
thanks for the replies. Will this work if the sum amount are in 13 th column or somewhere else ? I could not find them working...

will this work if we need to find the sum on 13th field. File may contain around 30 fields
sum2.awk

{
gsub(/\"| +/,"",$13)
sum += $13

}
END {
print "Sum: ", sum;
}


$ awk -f sum2.awk file

No, it wouldn't work, because awk does not know what character to use as a field separator, so it does not know what you mean when you refer to $13.

You can specify a regexp as a separator:

I had to increase the field number by 1 because with this solution awk would treat the first " as a field delimiter and presume that the first field was empty.

Thanks,

this works fine if all the columns are included in " "
In my case they are not. Sorry for not telling that.

"1",,,,,"X1211","1",

there may be empty fields seperated by commas.
If so how to change the field seperator and how to obtain the sum of 13th column ?

awk -F '[,]' '{ gsub(/\"| +/,"",$13);sum+=$13 } END { printf "Sum: 0.2%d",sum }' file

this worked. Now can i get sum of only those rows matching X1 and X2 ?

thanks for all your replies