DEV Community

Discussion on: One-liner to sum up numbers from a CSV file

View post

Replies for: Single command oneliner :) awk -F, '{if(NR==1)next;total+=$2}END{print total}' shopping.csv Enter fullscreen mode Exit fullscr...

Collapse
 
netikras profile image
Darius Juodokas •

Or a shorter (less verbose) version:

awk -F, 'FNR>1{total+=$2}END{print total}' shopping.csv
Enter fullscreen mode Exit fullscreen mode
Collapse
 
sfkulyk profile image
Sergii Kulyk • • Edited 
awk -F, '{sum+=$2}END{print sum}' shopping.csv
Enter fullscreen mode Exit fullscreen mode 
cut -d, -f2 a.txt|paste -s -d+|bc
Enter fullscreen mode Exit fullscreen mode