Test File to Excel Activity


#1

Hi mates,

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.

@arivu96


#2

Please share the sample text file. @nithin2304


#3

@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 3­4 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 GRP­SWING, 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 GRP­SWING, 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 GRP­SWING, 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