Create a CSV file using matched content from PDFs

Talk, speculate, discuss, pontificate. As long as it pertains to Hazel.

Moderators: Mr_Noodle, Moderators

Hi,

I had an idea and I was curious to know if that might be possible.

I would like an hazel rule that match some data on a PDF and append the results in a CSV file.

I receive an email everytime there is a transaction on my bank account. If I save that email to PDF in the watched folder, I could extract data from that transaction (date, payee, etc..) and create a list of all transactions in the CSV file that I could then import in my budgeting software.

Would you have an idea on how to do that ?

Thanks
mimifred
 
Posts: 4
Joined: Wed Oct 30, 2013 9:28 am

You'd need a script to parse out that info and then write it to a csv. Hazel's pattern matching isn't well suited for cases where you have to match against an arbitrary number of elements. Plus, you'll definitely need a script to write to a csv file as there's no built-in action for that.
Mr_Noodle
Site Admin
 
Posts: 11193
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City


Return to Open Discussion