I used the following data to test.
11/16/11 8:58:09.000 AM, WIWEB-A, WIWEB-A_1, PASSED
11/16/11 8:58:09.000 AM, WIWEB-A, WIWEB-A_2, FAILED
11/16/11 8:58:09.000 AM, WIWEB-A, WIWEB-A_3, PASSED
11/16/11 8:58:09.000 AM, WIWEB-B, WIWEB-B_1, PASSED
11/16/11 8:58:09.000 AM, WIWEB-C, WIWEB-C_1, SKIPPED
11/16/11 8:58:09.000 AM, PI-A, PI-A_1, CANCELLED
11/16/11 8:58:09.000 AM, PI-A, PI-A_1, PASSED
11/16/11 8:58:09.000 AM, PI-B, PI-B_1, CANCELLED
11/16/11 8:58:09.000 AM, DC_A, DC_A_1, FAILED
11/16/11 8:58:09.000 AM, DC_B, DC_B_1, FAILED
i created field extractions to match your fieldnames.
... View more