I wrote some very quick and dirty code to import American Express PDF statements to CSV here. I could export the PDF to TXT and then process the text file with PowerShell.I had to revisit it the other day as I had a raft of PDF statements to convert and import into YNAB (and not just from AMEX).
Of course, all the bank and credit card vendors use a standard PDF format for statements so it was easy.
No, actually pretty much everyone just does their own thing. And by ‘own thing’ I mean PDFs that are not even consistent within themselves.
So: the joy of regular expressions. Continue reading “PowerShell: Converting PDF Bank Statements to PDF”