Add data with commas 1

[jestrada101]

How can I add data using awk or sed in a file that has commas?

example data

john 111,000
earl 112,000

I want to sum this data. I've tried the following but it will not add data with commas:

awk '{ sum += $4 }
END { print sum }' mydatafile.txt

 

[vgersh99]

what's the desired output of this sample file?

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[aigles]

To add field 2 containing comma instead of decimal point :

awk '{ sub(&quot;,&quot;, &quot;.&quot;, $2) ; sum+=$2} END {print sum}' mydatafile.txt


Jean Pierre.

 

[olded]

Hi:

you could delete the commas first:

tr -d , < data.file

Ed

 

[jestrada101]

Thanks all... I ended up using sed to remove..

sed s/,/''/g data.file | awk '{ sum += $2 } END { print sum}'

JE

 

[aigles]

You can remove the comma inside your awk script :

awk '{gsub(&quot;,&quot;, &quot;&quot;, $2); sum+=$2} END {print sum}'

Jean Pierre.

 

[jestrada101]

Cool... thanks!