chrisaroundtown
Technical User
I have text in a SCHEDULE field that looks like this:
.........................................................................................................BBBBBBBBBBBBBBB....................................................................................................................................................................................LLLLLLLLLLLLLLLLLLLLLLLLLLLLLL.........................................................................................................BBBBBBBBBBBBBBB............................................................
Believe it or not but this represents a staff member's schedule. Each character reprensents one minute. A dot "." indicates the staff member is due to on the phones for that minute, a "B" is a break and "L" is lunch.
In this example there are 120 dots before the first "B", I'd like to be able to count them and put them in one field, then I'd like to count the "B"'s and put that count in another field, then of course count the next set of dots and so on.
Basically I need to be able to say where a break falls in a shift and how long it is for.
Any ideas?
Thanks
Chris
.........................................................................................................BBBBBBBBBBBBBBB....................................................................................................................................................................................LLLLLLLLLLLLLLLLLLLLLLLLLLLLLL.........................................................................................................BBBBBBBBBBBBBBB............................................................
Believe it or not but this represents a staff member's schedule. Each character reprensents one minute. A dot "." indicates the staff member is due to on the phones for that minute, a "B" is a break and "L" is lunch.
In this example there are 120 dots before the first "B", I'd like to be able to count them and put them in one field, then I'd like to count the "B"'s and put that count in another field, then of course count the next set of dots and so on.
Basically I need to be able to say where a break falls in a shift and how long it is for.
Any ideas?
Thanks
Chris