1 Reply Latest reply: May 15, 2014 10:15 AM by Olly Bond RSS

    I don't know how to title this issue....

    killermonkey _

      Basically I'm trying to extract between 2-3 lines of data. It's that 2-3 that's giving me issues. Sometimes line 2 and 3 will be there and sometimes its information from either line 2 or line 3. I've tried everything I can think of i.e. using different combinations of headers, detail, footer and append in combination with different options in the advanced tab of the trap options. I'm at a loss. I need all the information if its there and blanks if its not.

       

      Here is a sample of the info

       

      2: AIR ABORT/IFE                   AI 

            EQUIP      S O R T I E             CAUSE  CAUSE                           S T A R T    S T O P

             ID      DATE NUMBER MOD           CODE   NARRATIVE                      DATE  TIME    DATE  TIME

            A5069   13161  706   01            MT1    DEVIATION DUE TO MX (AMXS)     13161 1501   13161 1501 

      THIS FLIGHTS NARRATIVE:  IMPROPER GEAR INDICATIONS 

                DEVIATION CAUSED BY MAINTENANCE EVENT # A131610274

            A5069   13163  922   01            MT1    DEVIATION DUE TO MX (AMXS)     13163 1114   13163 1114 

      THIS FLIGHTS NARRATIVE:  AI/MT1- JCN 131630160 

                DEVIATION CAUSED BY MAINTENANCE EVENT # A131630160

            A6101   13174  702   01            AI     AIR ABORT/IFE                  13174 0545   13174 0707 

                DEVIATION CAUSED BY MAINTENANCE EVENT # A131740007

      /code

       

      Line 1 will always be:

            A5069   13161  706   01            MT1    DEVIATION DUE TO MX (AMXS)     13161 1501   13161 1501

      /code

       

      line 2 will either be:

      "THIS FLIGHTS NARRATIVE:..."

      or

      "DEVIATION CAUSED BY..."

       

      if there is a line 3 it will be:

      "DEVIATION CAUSED BY..."

       

       

      As you can see from my sample report the first two have 3 lines of information (all of which I need) while the third one lacks the "FLIGHTS NARRATIVE" but has the "DEVIATION CAUSED BY..."

       

      Here is an example of a couple lines where the opposite happens:

       

            A6109   13169  914   01            OP2    OPS/AIRCREW (28BS)             13169 1445   13169 1445 

      THIS FLIGHTS NARRATIVE:  2407 #3 WEATHER DIVERT

            A6109   13171  931   01            OP1    9TH BOMB SQUADRON              13171 1104   13171 1104 

      THIS FLIGHTS NARRATIVE:   CREW TOOK TO 731 LINE FOR PRIORITY

      /code

       

      These have "THIS FLIGHTS NARRATIVE..." but lack the "DEVIATION CAUSED BY..."

       

       

      Any suggestions???

       

      Thank you for your help in advance.