We are looking for a coder to parse out a VCAL calendar file.
Sample file here: [url removed, login to view]
This sample file contains two events.
We need to a coder to write a script that will parse out every event in the file, and produce an Excel spreadsheet containing:
1. The first detectable email address in the description
2. The first detectable 11-digit telephone number in the description beginning 07
3. The event start time (DTSTART), in DD/MM/YYYY format
It's relatively simple for anyone that knows what they're doing.
The final file to parse is around 2MB.
PS. Please start your bid with YOLO so I know you've read this. I ignore blind bids, so many of them alas.
As a small addendum to this project, we would also like a second Excel sheet which is unique by email. The other information from the row will be from the most recent date entry.