By "filtering records" is meant the process of getting Lertap to produce its various results using only some of the records in the Data worksheet.

 

There are three ways it can be done.

 

The Move+ Menu has the "Recode a Data column" option which provides a flexible way to filter records.  The word "Delete" can be attached to certain data records, as can the word "Exclude".  In many cases this will be a very effective way to quickly remove or exclude records. Click here.

 

The NumericFilter2 macro will breakout, or select, only those Data records meeting a specified criterion. It's accessed via the Macs menu.

 

The special *tst control "card" may also be used to have Lertap filter records. Three examples of its use are:

 

 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 (that is, a new Excel workbook).

 

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

 

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 (a new Excel workbook).

 

When a *tst card is used, it has to be placed at the top of the CCs worksheet, it must be the first "card" (or line) in the CCs sheet. See this topic for a bit more information on *tst.