CSV data manipulation: Difference between revisions

Content added Content deleted
Line 2,723: Line 2,723:
<lang Nanoquery>def sum(record)
<lang Nanoquery>def sum(record)
sum = 0
sum = 0

for i in range(1, len(record) - 1)
for i in range(1, len(record) - 1)
sum = sum + int(record ~ i)
sum = sum + int(record ~ i)
end for
end for

return sum
return sum
end def
end def

open "file.csv"
open "file.csv"
add "SUM"
add "SUM"

for i in range($dbsize, 1)
for i in range($dbsize, 1)
(i ~ @"SUM") = sum(#i)
(i ~ @"SUM") = sum(#i)
end for
end for

write</lang>
write</lang>