GoFuckYourself.com - Adult Webmaster Forum - View Single Post

fris · 11-02-2012, 07:22 AM

If you want to parse your csv statements to see how much cash was sent in total from other people here is a one liner.

Code:

awk -F '^"|","|"$' '{sum += $7} END {printf("%.2f\n", sum)}' paxum.csv | sed 's/^/$/; s/$/ credit/; s/\(.*[0-9]\)\([0-9]\{3\}\)/\1,\2/;t'

11-02-2012, 07:22 AM
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	Paxum for Linux Geeks If you want to parse your csv statements to see how much cash was sent in total from other people here is a one liner. Code: awk -F '^"\|","\|"$' '{sum += $7} END {printf("%.2f\n", sum)}' paxum.csv \| sed 's/^/$/; s/$/ credit/; s/\(.*[0-9]\)\([0-9]\{3\}\)/\1,\2/;t' __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff