4 Replies Latest reply: May 15, 2014 9:58 AM by Stephen Reid RSS

    "Tough" Trap - Help Please????

    Cherry Lane Music - IT Dept

      I've "thinned out" the data I've attached so that the post doesn't become confusing.  In reality, there are more lines that are in the middle that we have been successful at trapping. In the following (thinned out) sample data I need to:

       

      keep the lines that start with

      "In Account with :" 

       

      and keep the Song Titles

      "ADDICTED TO THAT RUSH (0010076)"

      "ADDICTED TO THAT RUSH 2 (0010077)"

       

      -but-

       

      NOT get the lines that say "Song Total"

       

      -and-

       

      NOT get the lines that say "For the Period :.....".

       

      Can anyone help us?

       

      [email="it@cherrylane.com"]it@cherrylane.com[/email]

       

      Thanks,

      The Cherry Lane Music IT Gang....

       

      -


      Sample Data Starts Here----


       

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH (0010076)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    2          2

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH (0010076)                             (Continued)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    3          3

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH (0010076)                             (Continued)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    4          4

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH (0010076)                             (Continued)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    5          5

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH (0010076)                             (Continued)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    6          6

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH (0010076)                             (Continued)

      Song Total

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH 2 (0010077)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    2          2

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH 2 (0010077)                             (Continued)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    3          3

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH 2 (0010077)                             (Continued)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    4          4

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH 2 (0010077)                             (Continued)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    5          5

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH 2 (0010077)                             (Continued)

      In Account with : (000639) DREAMWORKS SONGS (CHERRY LANE INCOME)             95-5737773     Page:    6          6

      For the Period  : JULY 2000 to DECEMBER 2000

      ADDICTED TO THAT RUSH 2 (0010077)                             (Continued)

      Song Total