Editor › Data Set-level Operations › Exclude

Exclude

Use the Exclude command to exclude all lines that match a specified pattern or string. The editor shows all records except for those that match the Exclude criteria.

Follow these steps:

1. Right-click anywhere in the editor, click Data Set-level Operations, Exclude.

   The Exclude dialog displays.

2. Specify the following values:

   Exclude string

   Specifies the string to exclude

   Start column

   Specifies the first, or leftmost, column in which to search

   End column

   Specifies the last, or rightmost, column in which to search

   Note: If the end column is not also specified, the specified string must begin the in the start column.

3. Specify the following options:

   Next

   Start from the current position in the file and locate the next occurrence of the specified string

   Previous

   Start from the current position in the file and locate the previous occurrence of the specified string

   First

   Start at the beginning of the file and locate the first occurrence of the specified string

   Last

   Start at the end of the file and locate the last occurrence of the specified string

   Character

   Match strings anywhere in a word

   Word

   Match only complete words

   Prefix

   Match only strings at the beginning of words

   Suffix

   Match only strings at the end of words

4. Click one of the following buttons:

   Exclude

   Excludes a single item.

   Exclude All

   Excludes all items.

   The dialog closes and the editor refreshes, hiding from view any lines that match the excluded criteria. Contiguous excluded lines are displayed as a single line of dashes.

More information:

Data Set-level Operations

Flip

Locate

Find/Change

Reset