Skip to main content Skip to complementary content

Filtering values using patterns

The Pattern tab of the profiling area shows a graphical representation of the type and number of characters your data is made of.

About this task

This example uses a dataset with typical customer information, such as their names, email, company they work in, or their subscription date.

Dataset containing customer information.

Procedure

  1. Select a column containing data that you want to filter, Email for example.
  2. In the profiling area, click the Pattern tab.
    The different patterns used in this column are displayed in the form of a chart. Because this column uses text data, the chart shows the repartition of the data using word-based patterns.
    Word-based patterns displayed in the form of a chart.
  3. Switch to the character-based view by clicking the A icon.
    This can give you another point of view to analyze your data.
    A-based patterns displayed in the form of a chart.
  4. Switch back to the word-based view by clicking the Text icon.
  5. Click the top bar to apply a filter on the most common pattern.

    The preparation now only displays the rows with the [word]@[word].[word] format.

    You can also use Ctrl + Click or Shift + Click to select multiple values at the same time and apply a more complex filter.

  6. While pressing the Ctrl button, click the bar corresponding to the [word]_[word]@[word].[word] pattern to add this filter to the previous one.
    The grid now only displays the data corresponding to those two filters.
    Filters applied.
  7. In the Functions panel, click a function to execute it on the data you filtered, Delete these Filtered Rows for example.
  8. In the filter bar, click the cross in each individual filter or click the garbage bin icon to clear the filters and display the whole dataset again.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!