Solved

generate report from log file

Posted on 2013-11-24
3
248 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

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…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

749 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