Solved

generate report from log file

Posted on 2013-11-24
3
251 Views
Last Modified: 2013-11-25
i have a log file and the only thing i need from it to generate a report is: discharge date & reason for discharge. the each block starts with sentence
Log-Date: mm/dd/yyyy.

in situation A, the result would be:
Discharge Date: 10/15/2012
Reason: Discharged to home or self-care (routine discharge).

and in situation B, the result would be:
Discharge Date: 10/15/2013
Reason: Discharged to home or self-care (routine discharge).
Discharge Date: 09/15/2012
Reason: Discharged to hospital.

situation A
Log-Date: 10/26/2012. Patient's record created. Admission Date: 08/01/2012   Log-Date: 06/20/2013 Patient Discharged. Discharge Date:10/15/2012 Reason for Discharge:01 - Discharged to home or self-care (routine discharge).  Log-Date: 06/20/2013 Discharge Undone. Discharge Date:11/15/2012. Original Admission Date: 08/01/2012

Open in new window


situation B
Log-Date: 10/26/2013. Patient's record created. Admission Date: 08/01/2013   Log-Date: 06/20/2013 Patient Discharged. Discharge Date:10/15/2013 Reason for Discharge:01 - Discharged to home or self-care (routine discharge).  Log-Date: 06/20/2013 Discharge Undone. Discharge Date:10/15/2013. Original Admission Date: 08/01/2013 Log-Date: 
02/26/2013. Patient's record created. Admission Date: 03/01/2013   Log-Date: 04/20/2013 Patient Discharged. Discharge Date:09/15/2012 Reason for Discharge:03 - Discharged to hospital. 

Open in new window


any help, comment or feedback would be deeply appreciated.
0
Comment
Question by:s_hausen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
Terry Woods earned 500 total points
ID: 39673646
I can't help with the CF code, but I can provide a regex pattern:

Discharge Date:(\d\d?/\d\d?/\d{4})\s*Reason for Discharge:\d* - ((?:(?!Log-Date:).)*)

Open in new window


The above pattern should capture your two values of interest into capturing groups, which hopefully you will know how to use with CF!
0
 
LVL 35

Expert Comment

by:Terry Woods
ID: 39673649
The pattern appears to pass testing here: http://www.myregextester.com/?r=e699fbe3
0
 

Author Closing Comment

by:s_hausen
ID: 39676600
helped me to solve the problem.
0

Featured Post

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question