Difference between revisions of "importing paypal csv into gnucash"

From thelinuxwiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 2: Line 2:
  
  
−
<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"}'  
+
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]]

Latest revision as of 21:17, 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"}'

Retrieved from "http://www.thelinuxwiki.com/index.php?title=importing_paypal_csv_into_gnucash&oldid=573"