dates in Starbucks


In yesterday’s post, one of the needed cleaning was to extract date and day of week from the string:
. list date in 1/5

     +--------------------------------------------+
     |                                       date |
     |--------------------------------------------|
  1. |  Date: August 31, 2015 at 1:42:41 PM GMT+8 |
  2. | Date: August 24, 2015 at 12:36:55 PM GMT+8 |
  3. |    Date: July 27, 2015 at 2:51:27 PM GMT+8 |
  4. |    Date: July 20, 2015 at 2:45:43 PM GMT+8 |
  5. |    Date: July 20, 2015 at 2:07:49 PM GMT+8 |
     +--------------------------------------------+

Continue reading