Upcoming Events Report: Difference between revisions

Revision as of 18:41, 17 September 2018

Navigate to https://ces.fas.harvard.edu/api/events/between/YYYY-MM-DD/YYYY-MM-DD
Copy and paste the data into http://www.jsonquerytool.com/. Make sure query type is JSONPath
Run this expression: $.items[?(@.calendar=='public')].['title','location','startDateTime','endDateTime']
Copy output to Sublimetext.
Run this regular expression: [0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}-[0-9]{2}-[0-9]{2}
Edit all lines to match this format: 12:34:56
Remove commas, quotation marks, tabs, and square brackets from beginnings and ends of lines. Leave a line break at the end.
Run this regular expression: (?:[^\n]*\n){4}
Change every first and second line break into a tab.
Copy and paste the whole thing into Excel.
Format dates with the following expression: mmmm d, yyyy, h:mmAM/PM

@@ Line 3: / Line 3: @@
 # Run this expression: <code>$.items[?(@.calendar=='public')].['title','location','startDateTime','endDateTime']</code>
 # Copy output to Sublimetext.
-# Run this Regex expression: <code>[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}-[0-9]{2}-[0-9]{2}</code>
+# Run this regular expression: <code>[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}-[0-9]{2}-[0-9]{2}</code>
 # Edit all lines to match this format: 12:34:56
 # Remove commas, quotation marks, tabs, and square brackets from beginnings and ends of lines.  Leave a line break at the end.
-# Run this regex expression: <code>(?:[^\n]*\n){4}</code>
+# Run this regular expression: <code>(?:[^\n]*\n){4}</code>
 # Change every first and second line break into a tab.
 # Copy and paste the whole thing into Excel.
 # Format dates with the following expression: <code>mmmm d, yyyy, h:mmAM/PM</code>