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?