Skip to main content

ワンライナー.5.合計の計算(特定の列の)

PHP

bash
cat a.txt | php -B '$sum = 0;' -R '$sum += explode(" ", $argn)[2];' -E 'echo $sum . "\n";'

Bash

bash
cat a.txt | awk '{ sum += $3 } END { print sum }'

略さず書くならこう

bash
cat a.txt | awk 'BEGIN { sum = 0 } { sum += $3 } END { print sum }'

Ruby

bash
cat a.txt | ruby -ane 'BEGIN { sum = 0 }; sum += $F[2].to_i; END {puts sum}'

PowerShell

powershell
Import-Csv a.csv | Measure-Object -Sum -Property Length