Solved

generate report from log file

Posted on 2013-11-24
3
243 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
  • 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 your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
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 …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now