Hi,
I have been trying to get data from a Text file (See Input Table) into a structured table..(see Output Table).
My current issue is that the data also fetches the Adherence summary section(In Red, this is the subtotal over the above data).
All I need is the detail in Blue, the red section must be ignored.
Input:
Output:
I have been trying to get data from a Text file (See Input Table) into a structured table..(see Output Table).
My current issue is that the data also fetches the Adherence summary section(In Red, this is the subtotal over the above data).
All I need is the detail in Blue, the red section must be ignored.
Input:
Code:
From: 04/01/16 IEX TotalView Detail and Summary
To: 04/21/16 Schedule Adherence Report
Shift: 0 All Day Friday 04/22/16 Page: 2
Printed: 16:38 04/22/16 By: Demo, User Station: 476
[COLOR=#0000ff]MU: 702 Campaign[/COLOR]
Sorted by: Name Activity Matching Range: 00:00 From/To Variance: 00:00 Activity Duration Variance: 00:00
Report Across Agent Moves: No Report Agent Moves: No
[COLOR=#0000ff]Team: Team 2[/COLOR]
[COLOR=#0000ff]13325 Surname1, Name1[/COLOR] - Adherence Summary
-------- Adherence --------- ------------------ Conformance ------------------
Scheduled Scheduled Actual Min. In Min.Out Perc. In +/- Min. Perc. In Percent of Percent of
Activities Time Time Adhere Adhere Adhere Conform Conform Total Sched. Total Actual
-------------------- ---------- ---------- -------- -------- ------ --------- -------- ------------ ------------
==================== ========== ========== ======== ======== ====== =========
Total 0:00 0:00 0 0 0 % +0
[COLOR=#0000ff]Date: 04/01/16[/COLOR] - Adherence Summary
-------- Adherence --------- ------------------ Conformance ------------------
Scheduled Scheduled Actual Min. In Min.Out Perc. In +/- Min. Perc. In Percent of Percent of
Activities Time Time Adhere Adhere Adhere Conform Conform Total Sched. Total Actual
-------------------- ---------- ---------- -------- -------- ------ --------- -------- ------------ ------------
[COLOR=#0000ff]Logout 10:00 10:00 600 0 100 % +0 100 % 100 % 100 [/COLOR]%
==================== ========== ========== ======== ======== ====== =========
[COLOR=#0000ff]Total 10:00 10:00 600 0 100 % +0[/COLOR]
[COLOR=#0000ff]Date: 04/02/16 [/COLOR]- Adherence Summary
-------- Adherence --------- ------------------ Conformance ------------------
Scheduled Scheduled Actual Min. In Min.Out Perc. In +/- Min. Perc. In Percent of Percent of
Activities Time Time Adhere Adhere Adhere Conform Conform Total Sched. Total Actual
-------------------- ---------- ---------- -------- -------- ------ --------- -------- ------------ ------------
[COLOR=#0000ff]Login 9:00 0:00 0 540 0 % -540 0 % 90 % 0 %
Logout 1:00 10:00 60 0 100 % +540 1000 % 10 % 100 %[/COLOR]
==================== ========== ========== ======== ======== ====== =========
[COLOR=#0000ff]Total 10:00 10:00 60 540 10 % +0[/COLOR]
[COLOR=#ff0000]Team: - Adherence Summary
-------- Adherence --------- ------------------ Conformance ------------------
[/COLOR][COLOR=#ff0000]Scheduled Scheduled Actual Min. In Min.Out Perc. In +/- Min. Perc. In Percent of Percent of
Activities Time Time Adhere Adhere Adhere Conform Conform Total Sched. Total Actual
-------------------- ---------- ---------- -------- -------- ------ --------- -------- ------------ ------------
Login 9:00 0:00 0 540 0 % -540 0 % 45 % 0 %
Logout 11:00 20:00 660 0 100 % +540 182 % 55 % 100 %
==================== ========== ========== ======== ======== ====== =========
Total 20:00 20:00 660 540 55 % +0
[/COLOR]
____________________
From: 04/01/16 IEX TotalView Detail and Summary
To: 04/21/16 Schedule Adherence Report
Shift: 0 All Day Friday 04/22/16 Page: 2
Printed: 16:38 04/22/16 By: Demo, User Station: 476
[COLOR=#0000ff]MU: 702 Campaign
[/COLOR]
Sorted by: Name Activity Matching Range: 00:00 From/To Variance: 00:00 Activity Duration Variance: 00:00
Report Across Agent Moves: No Report Agent Moves: No
Team: Team 1
[COLOR=#0000ff]
13326 Surname2, Name2 [/COLOR]- Adherence Summary
-------- Adherence --------- ------------------ Conformance ------------------
Scheduled Scheduled Actual Min. In Min.Out Perc. In +/- Min. Perc. In Percent of Percent of
Activities Time Time Adhere Adhere Adhere Conform Conform Total Sched. Total Actual
-------------------- ---------- ---------- -------- -------- ------ --------- -------- ------------ ------------
==================== ========== ========== ======== ======== ====== =========
Total 0:00 0:00 0 0 0 % +0
[COLOR=#0000ff]Date: 04/01/16[/COLOR] - Adherence Summary
-------- Adherence --------- ------------------ Conformance ------------------
Scheduled Scheduled Actual Min. In Min.Out Perc. In +/- Min. Perc. In Percent of Percent of
Activities Time Time Adhere Adhere Adhere Conform Conform Total Sched. Total Actual
-------------------- ---------- ---------- -------- -------- ------ --------- -------- ------------ ------------
[COLOR=#0000ff]Logout 10:00 10:00 600 0 100 % +0 100 % 100 % 100 %[/COLOR]
==================== ========== ========== ======== ======== ====== =========
[COLOR=#0000ff]Total 10:00 10:00 600 0 100 % +0[/COLOR]
[COLOR=#0000ff]Date: 04/02/16 [/COLOR]- Adherence Summary
-------- Adherence --------- ------------------ Conformance ------------------
Scheduled Scheduled Actual Min. In Min.Out Perc. In +/- Min. Perc. In Percent of Percent of
Activities Time Time Adhere Adhere Adhere Conform Conform Total Sched. Total Actual
-------------------- ---------- ---------- -------- -------- ------ --------- -------- ------------ ------------
[COLOR=#0000ff]Login 9:00 0:00 0 540 0 % -540 0 % 90 % 0 %
Logout 1:00 10:00 60 0 100 % +540 1000 % 10 % 100 %[/COLOR]
==================== ========== ========== ======== ======== ====== =========
[COLOR=#0000ff]Total 10:00 10:00 60 540 10 % +0[/COLOR]
[COLOR=#ff0000]Team: - Adherence Summary
-------- Adherence --------- ------------------ Conformance ------------------
Scheduled Scheduled Actual Min. In Min.Out Perc. In +/- Min. Perc. In Percent of Percent of
Activities Time Time Adhere Adhere Adhere Conform Conform Total Sched. Total Actual
-------------------- ---------- ---------- -------- -------- ------ --------- -------- ------------ ------------
Login 9:00 0:00 0 540 0 % -540 0 % 45 % 0 %
Logout 11:00 20:00 660 0 100 % +540 182 % 55 % 100 %
==================== ========== ========== ======== ======== ====== =========
Total 20:00 20:00 660 540 55 % +0[/COLOR]
____________________
Output: