Filter rows/cells on value

Filter rows from the dataset that contain specific values. Alternatively, this processor can clear content from matching cells instead of filtering entire rows.

Options

Action

Select the action to perform on matching (in range) rows or cells:

  • Keep matching rows only

  • Remove matching rows

  • Clear content of matching cells

  • Clear content of non-matching cells

Column

Apply the matching condition to the following:

  • A single column

  • An explicit list of columns

  • All columns matching a regex pattern

  • All columns

Note

When applying the match condition to several columns (multiple, pattern, all), select whether the row will be considered as matching if all columns match (ALL) or at least one column matches (OR).

has values

Input the values for the match condition. A cell will match if it matches one or more values in the list.

Match mode

Determine the match type:

  • Complete value: the entire cell must match the searched value(s)

  • Substring: the cell contains the searched value(s)

  • Regular expression: the cell matches the regex

Note

The regex is not anchored.

Normalization mode

Specify how to find the match:

  • Exact (no transformation): use case-sensitive search

  • Ignore case: use case-insenstive search

  • Normalize (ignore accents): use accents-insensitive search

Note

Accent-insensitive normalization is only available for complete value matching.