I need to process a text file to extract (example below) patient name, medical record number (MRN), DOB (convert DOB to age), and gender. The file will have a variable amount of patients per day. I need to then paste these variables into a new text file. Any suggestions?
As of: 09/14/09 08:22 Page 1
S C H E D U L I N G M A N A G E M E N T
Non-worksheet Daily Summary
Resource: DOC
Date: 09/14/09
Time Dur Appointment Type State Requester
09:00 20 RETURN PATIENT VISIT Confirmed
Person: DOE, JOHN
Home Phone: (706) 788-8888 MRN: 001234567 DOB: 08/09/1965 Gender: Male
Reason: HEALTH MAINT
09:15 20 RETURN PATIENT VISIT Confirmed
Person: DOE, JANE
Home Phone: (803) 688-8888 MRN: 007654321 DOB: 12/22/1954 Gender: Female
Reason: health maint
09:20 20 RETURN PATIENT VISIT Confirmed
Person: DOE, BROTHER
Home Phone: (803) 666-6666 MRN: 001111111 DOB: 09/04/2007 Gender: Male
Reason: 6 MOS CHECK
09:30 20 RETURN PATIENT VISIT Confirmed
Person: DOE, SISTER
Home Phone: (706) 999-9999 MRN: 002222222 DOB: 09/27/2008 Gender: Female
Reason: HEALTH MAINT
*** End of 09/14/09 appointments ***
* ** E N D O F R E P O R T * * *