Hello,
The attached string of data is a number of different progress updates for a single sample query (called number 12345). I am trying write script that provides a couple of different outputs:
(1) There are multiple "scheduling dates" - I need to create a master ScheduleDate that just pulls the timestamp for the very first "Update" in time that is "Scheduled."
(2) Generate a list that includes this query number 12345 when the "Update" field has changed from anything other than "Unable to Contact" to "Unable to Contact" (e.g. a list generated on both 28-Jun-12 and 17-Jul-12 would include this query number, but not on 01-Jul-12 because the "Update" field is the same.
Thanks for the help!
| Number | Update | Update Timestamp | Status Timestamp |
| 12345 | Dispatched | 28-Jun-12 | 28-Jun-12 |
| 12345 | Unable to Contact | 28-Jun-12 | 28-Jun-12 |
| 12345 | Unable to Contact | 01-Jul-12 | 01-Jul-12 |
| 12345 | Scheduled | 03-Jul-12 | 05-Jul-12 |
| 12345 | In Progress | 05-Jul-12 | 05-Jul-12 |
| 12345 | In Progress | 05-Jul-12 | 05-Jul-12 |
| 12345 | In Progress | 05-Jul-12 | 05-Jul-12 |
| 12345 | Unable to Contact | 10-Jul-12 | 10-Jul-12 |
| 12345 | Scheduled | 12-Jul-12 | 13-Jul-12 |
| 12345 | Scheduled | 12-Jul-12 | 10-Jul-12 |
| 12345 | In Progress | 13-Jul-12 | 13-Jul-12 |
| 12345 | Unable to Contact | 17-Jul-12 | 17-Jul-12 |
| 12345 | Unable to Contact | 10-Aug-12 | 10-Aug-12 |
| 12345 | Complete | 12-Aug-12 | 12-Aug-12 |
