Got a new challenge now. Pl do help. Pl. find the attached screenshot of the Text file.
Under the active problem details , I need to get the first column data i.e Problem data alone and store that in a excel file.
I iterated the test file to find active problem details and increment the counter if not found and break once it is found, am splitting the string based on the counter value. But what is get is the entire data in the excel.
Pl help in that issue. And this follows for all the sections in that text file. The issue is, I need to get only the data which I require from the table. The text file is dynamic, it’ll change based on the input.
@lasithdilshan20 .txt file is not getting uploaded. Lemme attach the contents of it.
BLAKESLEE, ROBERT W. 63y M Patient Chart Report 03/27/18 12:42 am
DOB: 04/22/54
CASSIDY MEDICAL GROUP
INC
Active Problems Details
Problem Code Specialty Chronicity Status Onset Last Assessment User Updated
Diabetes Mellitus Type 2 E11.9 Chronic Active 04/03/15 Unchanged Robert 04/03/2015
Without Complication Barron
History: Chronic Active 04/03/15 Unchanged Robert 04/03/2015
Glaucoma H40.003 Chronic Active 04/03/15 Unchanged Robert 04/03/2015
Barron
History: Chronic Active 04/03/15 Unchanged Robert 04/03/2015
Hypercholesterolemia E78.00 Chronic Active 04/03/15 Unchanged Robert 04/03/2015
Essential Barron
History: Chronic Active 04/03/15 Unchanged Robert 04/03/2015
Vitamin D Deficiency E55.9 Chronic Active 04/03/15 Unchanged Robert 04/03/2015
Barron
History: Chronic Active 04/03/15 Unchanged Robert 04/03/2015
Herpes Simplex Type Ii A60.9 Chronic Active 09/20/07 Stable Wendy 04/05/2016
Martin
History: Chronic Active 09/20/07 Stable Wendy 09/20/2007
History: Chronic Active 09/20/07 Stable Robert 04/05/2016
Medications Details Active Medications
Dicyclomine HCl 20 MG Tablet
Rx: Issued
Diagnosis: Method: Print
Drug: Dicyclomine HCl 20 MG Tablet Date: 06/03/16
Sig: Provider: ROBERT H. BARRON
Dose: 30 tablet Pharmacy:
Days: 30
Refills: 0
DAW: N
Directions: 1 by mouth 34 times daily as needed for
intestinal cramping.
Active Allergies
Allergy Type Encounter Status Onset Reactions User Reviewed
Page 1 of 4
BLAKESLEE, ROBERT W. 63y M Patient Chart Report 03/27/18 12:42 am
DOB: 04/22/54
CASSIDY MEDICAL GROUP
INC
Active Allergies
Allergy Type Encounter Status Onset Reactions User Reviewed
No Known Allergies Allergy 05/11/2017 Active 20081105 Georgina Gonzalez 05/11/2017
Allergy 04/10/2017 Active 20081105 Maggie Tindell 04/10/2017
Allergy 08/22/2016 Active 20081105 Georgina Gonzalez 08/22/2016
Allergy 06/02/2016 Active 20081105 Georgina Gonzalez 06/02/2016
Allergy 04/05/2016 Active 20081105 Georgina Gonzalez 04/05/2016
Allergy 09/03/2015 Active 20081105 Georgina Gonzalez 09/03/2015
Allergy 04/03/2015 Active 20081105 Georgina Gonzalez 04/03/2015
Allergy 03/10/2015 Active 20081105 Georgina Gonzalez 03/10/2015
Allergy 10/16/2014 Active 20081105 Georgina Gonzalez 10/16/2014
Allergy 10/01/2014 Active 20081105 Georgina Gonzalez 10/01/2014
Allergy Active 11/05/2008 11/05/2008
Clinical History Details for All History
Surgical History Qualifiers Comments User Updated
History of eye surgery Georgina 10/01/2014
Social History Qualifiers Comments User Updated
No tobacco use Result: normal Georgina 10/01/2014
Smoking status : Never smoker, Georgina 10/01/2014
Result: normal
Family History Qualifiers Comments User Updated
Maternal history of cataract Georgina 10/01/2014
Patient Immunization Details All Dates
Unless otherwise noted, immunizations were administered at the following location:
CASSIDY MEDICAL GRPSWING, 2095 W VISTA WAY STE 218, Vista, CA 920836010
Dose Action Date Manufacturer / Comments User Last Update
Hep B
1 Administered 10/10/17 Site: Left Arm Manuf: Merck & Co., Inc. Lot#: L044917 Exp: Georgina Gonzalez 10/10/17
10/05/18
Page 2 of 4
BLAKESLEE, ROBERT W. 63y M Patient Chart Report 03/27/18 12:42 am
DOB: 04/22/54
CASSIDY MEDICAL GROUP
INC
Patient Immunization Details All Dates
Unless otherwise noted, immunizations were administered at the following location:
CASSIDY MEDICAL GRPSWING, 2095 W VISTA WAY STE 218, Vista, CA 920836010
Dose Action Date Manufacturer / Comments User Last Update
1 Ordered Georgina Gonzalez 10/10/17
Influenza
1 Administered 01/10/11 Site: Right Arm Manuf: Other Lot#: U3621DA Exp: 06/30/11 Georgina Gonzalez 01/10/11
1 Ordered Georgina Gonzalez 01/10/11
2 Administered 11/06/12 Site: Left Arm Manuf: sanofi pasteur Lot#: UH755AA Exp: Georgina Gonzalez 11/06/12
06/30/13
2 Ordered Georgina Gonzalez 11/06/12
3 Administered 11/14/13 Site: Left Arm Manuf: sanofi pasteur Lot#: UH905AB Exp: Marjorie Maddex 11/14/13
06/30/14
3 Ordered Marjorie Maddex 11/14/13
4 Administered 09/30/14 Site: Left Arm Manuf: sanofi pasteur Lot#: UI195AA Exp: Georgina Gonzalez 09/30/14
06/30/15
4 Ordered Georgina Gonzalez 09/30/14
PPV (Pneumovax 23)
1 Administered 04/10/17 Site: Left Arm Manuf: Other manufacturer Lot#: M029681 Maggie Tindell 04/10/17
Exp: 01/22/18
1 Ordered Maggie Tindell 04/10/17
Prevnar (PCV 13)
1 Administered 04/05/16 Site: Left Arm Manuf: Other manufacturer Lot#: M56417 Georgina Gonzalez 04/05/16
Exp: 06/01/17
1 Ordered Georgina Gonzalez 04/05/16
Quad Fluzone .5mg
1 Administered 10/06/15 Site: Left Arm Manuf: sanofi pasteur Lot#: UI422AA Exp: Georgina Gonzalez 10/06/15
06/30/16
1 Ordered Georgina Gonzalez 10/06/15
2 Administered 10/04/16 Site: Left Arm Manuf: sanofi pasteur Lot#: UI629AA Exp: Olivia Kayser 10/04/16
06/30/17
2 Ordered Olivia Kayser 10/04/16
Page 3 of 4
BLAKESLEE, ROBERT W. 63y M Patient Chart Report 03/27/18 12:42 am
DOB: 04/22/54
CASSIDY MEDICAL GROUP
INC
Patient Immunization Details All Dates
Unless otherwise noted, immunizations were administered at the following location:
CASSIDY MEDICAL GRPSWING, 2095 W VISTA WAY STE 218, Vista, CA 920836010
Dose Action Date Manufacturer / Comments User Last Update
Tdap
1 Administered 01/10/11 Site: Left Arm Manuf: Other Lot#: C3518BA Exp: 08/27/12 Georgina Gonzalez 01/10/11
1 Ordered Georgina Gonzalez 01/10/11
Page 4 of 4
ashokkarale
Anil_G
lrtetala
B_o_D
postwick
shaik.muktharvalli1
marina.dutta
Evelyn_Lu
Ejaz_Ab
ppr