Page 1 of 1

Create a CSV file using matched content from PDFs

PostPosted: Wed Sep 27, 2017 11:05 am
by mimifred
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

Re: Create a CSV file using matched content from PDFs

PostPosted: Thu Sep 28, 2017 10:25 am
by Mr_Noodle
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.