I
In-Thought
While using data extracted from Remedy Management Software - need to filter
the information to specific areas of concern. Below is the header line and
one record for example.
Case ID+ Create Date Resolved
Time Status* Category* Type* Item* Group+ Individual+ Summary* Work
Log(240000008)
HD0000000321385 3/10/2009 10:39 3/31/2009 9:46 Resolved LAN Other Other DC
OSS Any Person User reports their Wireless keyboard is not working. 3/10/2009
10:48:08 AM jermaine.myers The customer contacted the Help Desk via: Phone
The customer was notified that their problem was being addressed: No The
problem could be duplicated: NA The full problem description is: User
reports their Wireless keyboard is not working. User has changed the
Batteriers. 3/27/2009 11:02:48 AM bruce.bates1 e-mail sent: but got
out of Office Reply -----Original Message----- From: Bates, Bruce Mr
NGDC Sent: Friday, March 27, 2009 11:02 AM To: Williamson, Octavia SSG
NGDC Subject: Ticket 321385 (UNCLASSIFIED) Classification: UNCLASSIFIED
Caveats: NONE Does this still remain an issue: User reports their
Wireless keyboard is not working. Classification: UNCLASSIFIED Caveats:
NONE 3/27/2009 1:00:22 PM patrick.scott2 Called user, vm says no one
will be in until April 6th. 3/31/2009 9:46:16 AM patrick.scott2 Closing
out ticket, user will not be in until April 6th. Will ask user to resubmit
ticket upon there arrival.
Summary* and Work Log(240000008) columns cotain more detailed notes of the
situation and is the focus of this concern.
Is there a way to run multiple filters on these two columns where each
keyword filters the selections further? For instance, if the keyword
"internet" was used to perform the first filter, then "java" for the second,
and then "78593" in order to find information that may not be located in any
particular order but contained somewhere within the text?
the information to specific areas of concern. Below is the header line and
one record for example.
Case ID+ Create Date Resolved
Time Status* Category* Type* Item* Group+ Individual+ Summary* Work
Log(240000008)
HD0000000321385 3/10/2009 10:39 3/31/2009 9:46 Resolved LAN Other Other DC
OSS Any Person User reports their Wireless keyboard is not working. 3/10/2009
10:48:08 AM jermaine.myers The customer contacted the Help Desk via: Phone
The customer was notified that their problem was being addressed: No The
problem could be duplicated: NA The full problem description is: User
reports their Wireless keyboard is not working. User has changed the
Batteriers. 3/27/2009 11:02:48 AM bruce.bates1 e-mail sent: but got
out of Office Reply -----Original Message----- From: Bates, Bruce Mr
NGDC Sent: Friday, March 27, 2009 11:02 AM To: Williamson, Octavia SSG
NGDC Subject: Ticket 321385 (UNCLASSIFIED) Classification: UNCLASSIFIED
Caveats: NONE Does this still remain an issue: User reports their
Wireless keyboard is not working. Classification: UNCLASSIFIED Caveats:
NONE 3/27/2009 1:00:22 PM patrick.scott2 Called user, vm says no one
will be in until April 6th. 3/31/2009 9:46:16 AM patrick.scott2 Closing
out ticket, user will not be in until April 6th. Will ask user to resubmit
ticket upon there arrival.
Summary* and Work Log(240000008) columns cotain more detailed notes of the
situation and is the focus of this concern.
Is there a way to run multiple filters on these two columns where each
keyword filters the selections further? For instance, if the keyword
"internet" was used to perform the first filter, then "java" for the second,
and then "78593" in order to find information that may not be located in any
particular order but contained somewhere within the text?