I am trying to get a script working to track my business miles/gas etc. I have excel worksheets with the everything set up and I have a memo on my blackberry that looks similar to this:
Date:
Odometer:
Price Per Gal:
Gallons:
I usually fill those in and then email it to myself and manually transfer them to my excel sheet. I am wondering if there is a way to make an applescript/automater workflow that could pull the values from the body of the email and make variables?
Or could I change the blackberry message to look more xml like:
And pull that from the email body somehow?
Thanks for any help or direction
Given the headers on each data entry, it would be easy to extract 4 values from an email. To do so, however, requires that you stick to the same headers use the same format for the date every time and decide whether you want a comma in the mileage or not. To extract the text from an email requires knowing the email client you’re using.
I am using Apple’s Mail.app (vers 3.5) to receive the email. Sent from a Blackberry Bold. I can enter the data in the same way each time, this is how my current emails go:
Date: 1/16
Odo: 7031
Price per gal ($): 2.059
Gallons: 16.897
Total Cost ($): 34.79
But I could change it to fit however the script needs it…
Edit: added mail version # just in case…