Previous Topic: Perform Data Set-Level OperationsNext Topic: Flip


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:

Perform Data Set-Level Operations

Flip

Locate

Find

Reset