Filtering records (*tst)

 

The *tst control "card" is a special one, used to have Lertap filter some of the records from whatever data set you happen to be working with.  Two examples of the *tst card have been briefly mentioned in the topics above; much more mention of *tst is found in the manual.

 

In December 2004 the *tst card gained some new smarts.  Now the filtering criteria may be more elaborate -- look at these examples:

 

 A) *tst c6=(CS001)

 

 B) *tst c6=(UCS001, CS001)

 

 C) *tst c6=(DL5, DL6, DXL7), c7=(WI)

 

In example A), all data records with CS001 in column 6 of the Data worksheet will be filtered out into a new data set.

 

In Example B), all records with either UCS001 or CS001 will be filtered out into a new data set.

 

In Example C), all records with either DL5, DL6, or DXL7 in column 6, and WI in column 7, will be filtered out into a new data set.

 

So, what are the "new smarts" we're talking about?  Well, it used to be the case that the filtering criteria could consist of just a single character, as in, for example, *tst c2=(W) and *tst c4=(B,G).  Now the criteria may be any length.  (There may be up to 20 criteria for each column.  In the examples above, in B) there are said to be two filtering criteria on column 6, while in example C) we'd say that there are three criteria on column 6.)

 

In June 2006 the Move+ Menu was blessed with a new option, Recode a Data column, which provides another way to filter records.  Now the word "Delete" can be attached to certain data records, as can the word "Exclude".  In some cases this may be a very effective way to quickly remove records. Click here.

 

In September 2010, the NumericFilter2 macro was added to Lertap's special macros workbook, Lertap5MacroSetA.xlam. This macro makes it easy to breakout, or select, only those Data records meeting a specified criterion. It's accessed via the Macs menu.