I need to be able to detect this pattern of events, in a series of events where the TERMINAL number is increasing by 1 and eventually has a status of 'S', in other words, I need to be detect the event(s) that have a status of 'S' where the preceding 5 events were increasing by 1 and had a status of 'F'.
_time TERMINAL DLDTYPE STATUS
2015-02-10T15:29:21.000-0500 1759512 U F
2015-02-10T15:29:31.000-0500 1759513 U F
2015-02-10T15:29:42.000-0500 1759514 U F 2015-02-10T15:30:17.000-0500 1759515 F S
2015-02-10T15:32:20.000-0500 1759516 F S
2015-02-10T15:33:31.000-0500 1759517 U F
2015-02-10T15:34:42.000-0500 1759518 U F