Difference between revisions of "importing paypal csv into gnucash"
From thelinuxwiki
(Created page with "script to format the paypal csv <p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf $1 "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8...") |
|||
| Line 1: | Line 1: | ||
script to format the paypal csv | script to format the paypal csv | ||
| − | <p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf $1 "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!="\"0.00\"") printf $1 "," $8 "," $12 "," "paypal fee for " $16 "\n"}' | + | |
| + | |||
| + | <p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf substr($1,2) "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!="\"0.00\"") printf substr($1,2) "," $8 "," $12 "," "paypal fee for " $16 "\n"}' | ||
[[category:gnucash]] | [[category:gnucash]] | ||
Revision as of 21:01, 11 October 2013
script to format the paypal csv
cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf substr($1,2) "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!="\"0.00\"") printf substr($1,2) "," $8 "," $12 "," "paypal fee for " $16 "\n"}'
