Conditional scripting to select one of many fields in a data set
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.