Help Need with Automating Bank of America CSV's

Hi All,

New here, but long time user of Hazel. I'm having some issues trying to automate the filing of some Bank of America CSV files.

Basically once a month, when our business account rolls over the statement, I download a CSV tab of the previous month. What I'm trying to do is have Hazel find those files, then rename them based on the date inside the CSV.

There's a field inside the csv that always reads as follows: Ending balance as of 09/28/2012

I want to take that date from that field and use it in the renaming of the file.

This is actually something I need for other Excel files as well, as I'm sure the method used to solve this, could also be used on others.

Could someone point me in the right direction?

Check the Buzz section. David Sparks has a video that will show you how to do it.