Not what you asked for, but what alternative file types does Citibank provide besides CSV?
Kind regards, Greg Feneis (Pixel 3) On Sun, Jun 16, 2019, 22:17 Michael DeBusk <mdeb...@gmail.com> wrote: > Some time back, Citibank decided it would stop offering its transactions in > QIF format. I edited the CSV in vim (I only had a few transactions) until > this past week, when I realized I can't be a good Linux nerd unless I > automate repetitive tasks. > > This is my attempt at an awk script specific to Citibank's file format. The > QIF needs some editing after it's done, but it'll save me a lot of time > until they change the format again. > > (I'd appreciate criticism from awk masters on the list.) > > #!/usr/bin/awk -f > BEGIN { > FS="," > print "!Account" > print "NLiabilities:Citibank:Costco Anywhere Visa" # Change to your > account > print "TCCard" > print "\\Statement Balance Date" > print "$Statement Balance" > print "^" > print "!Type:CCard" > } > FNR == 1 { next } > { > print "D"$2 > if ($3~/AUTOPAY/) { > print "PCitibank"; > print "T"sqrt($5^2); # This gets rid of the "-" before the amount > print "LAssets:Current Assets:"; # change to your checking account > print "MAutopay"; > } > else { > print "P"tolower(substr($3, 2, length($3)-2)); # This gets rid of > the double quotes around this string, and lower-case it > print "T-"$4; > print "LExpenses:&&"; > print "M&&"; > } > print "^" > } > > -- > Home: http://nlphilia.com * Blog: http://nlphilia.net > Registered Linux User #450983 * Ubuntu Counter Project #10548 > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.