"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?

it@cherrylane.com

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

[Jim Mathis]

Instr("addicted",[raw data]) .Or. Instr("account",[raw data]

Should work.

Jim

[Cherry Lane Music - IT Dept]

Please forgive my "beginerness". I understand the syntax and logic behind it. I'm just not clear where I would place the formula???

[Mike Urbonas]

Originally posted by Cherry Lane Music - IT Dept:
Please forgive my "beginerness". I understand the syntax and logic behind it. I'm just not clear where I would place the formula???The formula Jim suggested is a Data Filter. In Monarch, go to the Table window and select Data - Filter from the menu bar, or click on the icon with tiny check marks - that is the Data Filter button.

Now that you are in the Filter screen, click New, give your filter a name such as "No Total or For The Perod Lines" and enter the formula in the "Expression" section of the screen.

Jim's suggestion uses the INSTR function which should work. However I suggest as "best practice" to specify the data you definitely do NOT want to display when defining a data filter. For example:

Instr("Song Total",[raw data])+Instr("For the Period :",[raw data])=0

The INSTR function looks in the field [raw data] for the text string "Song Total" and "For the Period :" , and if it finds it, returns the character position the text string starts at. If it can't find the string, the INSTR expression will equal zero. Those are the data lines this filter will retain.

And here is an even easier formula that should work:

[raw data] NOT IN ("Song Total", "For the Period :")

which tells Monarch to display all the data lines in which the text string "Song Total" and/or "For the Period :" are "not in" the [raw data] data field.

Check out the Summer 2001 Monarch Report newsletter tip describing the IN and NOT IN operators in detail: http://www.datawatch.com/pdf/products/monarch/Newsletter_summer_2001.pdf

Thanks for getting started with Monarch,

Regards,
Mike

[Stephen Reid]

Hi,

If you send me a copy of your print file I will take a look at it for you.

Stephen Reid