GoFuckYourself.com - Adult Webmaster Forum - View Single Post

fris · 09-14-2012, 10:09 AM

Wanted to find a way to take my paxum incoming payments and parse it via the .csv file paxum generates.

Thought I would share.

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'

09-14-2012, 10:09 AM
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,359	Linux Geeks who use Paxum in here. Wanted to find a way to take my paxum incoming payments and parse it via the .csv file paxum generates. Thought I would share. 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