Upcoming Events Report

1. Navigate to https://ces.fas.harvard.edu/api/events/between/YYYY-MM-DD/YYYY-MM-DD
2. Copy the data starting excluding braces.
3. Paste it into http://www.jsonquerytool.com/. Make sure query type is JSONPath
4. Run this expression:

   $.items[?(@.calendar=='public')].['title','startDateTime','endDateTime']

1. Copy output to Sublimetext.
2. Run this Regex expression (including space at beginning):

    [0-9]{2}-[0-9]{2}-[0-9]{2}

1. Edit all lines to match this format: 12:34:56
2. Remove commas, quotation marks, tabs, and square brackets from beginnings and ends of lines. Leave a line break at the end.
3. Run this regex expression:

   (?:[^\n]*\n){3}

1. Change every first and second line break into a tab.
2. Copy and paste the whole thing into Excel
3. Format dates as March 14, 2018, 12:34pm