species8514
Board Regular
- Joined
- Oct 4, 2006
- Messages
- 98
Hi, I have a report that is run from another system, and unfortunately there is no way of altering the format of how it outputs the data. An example of what I get is:
Anne
9:00
10:36 a
11:49
13:34 c
14:35
15:10 a
17:00
bob
7:20
7:45 a
8:00
8:45
9:00 c
10:00
11:00 a
13:00
carly
20:00
20:10 a
20:20 c
21:00 a
22:30
It's probably easy, but I can't think of an easy solution, but essentially what I need to do is, return the value which matches the second instance of "a" for Bob, which would be 11:00.
Any help would be grateful.
Anne
9:00
10:36 a
11:49
13:34 c
14:35
15:10 a
17:00
bob
7:20
7:45 a
8:00
8:45
9:00 c
10:00
11:00 a
13:00
carly
20:00
20:10 a
20:20 c
21:00 a
22:30
It's probably easy, but I can't think of an easy solution, but essentially what I need to do is, return the value which matches the second instance of "a" for Bob, which would be 11:00.
Any help would be grateful.
