Summing Values ​​in a Single Line Comma Separated File

Question

EDIT: Thank you all. Python solution worked lightning fast :)

I have a file that looks like this:

132,658,165,3216,8,798,651

but MUCH is larger (~ 600 kB). There are no new lines except one at the end of the file.

And now I have to summarize all the values ​​that are. I expect the final result to be quite large, but if I summarized it in C ++, I have a bigmoon library, so this should not be a problem.

How do I do this, and in which language / program? C ++, Python, Bash?

Answer 1

Python

sum(map(int,open('file.dat').readline().split(',')))

Answer 2

, "Awk"

sed -e 's/,/\n/g' tmp.txt | awk 'BEGIN {total=0} {total += $1} END {print total}'

• - tmp.txt( )
• Awk ,

Answer 3

, bignum. :

str = ""
sum = 0
while input
    get character from input
    if character is not ','
        append character to back of str
    else
        convert str to number
        add number to sum
        str = ""
output sum

Answer 4

(2 ** 64)/600000 ( - 14 ), 8 " " C. , .

Answer 5

, . , . #, .

, (, 32-), , . -31 dword .

, double. .

Answer 6

http://www.koders.com/csharp/fid881E3E70CC37E480545A0C37C98BC8C208B06723.aspx?s=datatable#L12

# CSV-. , , 1 , , , 6000 .

.

Answer 7

python .

Answer 8

tr "," "\n" < file | any old script for summing

Ruby is convenient because it automatically processes large numbers. I can’t remember that Awk does arbitrary arithmetic precision, but if so, you can use

awk 'BEGIN {RS="," ; sum = 0 }
     {sum += $1 }
     END { print sum }' < file