Filter a list

The quickest method of list filtering

This is the right tool for the job if you wish to process a large list and filter out only items that match specific criteria.

The tool quickly scans the entire list line by line and rejects or includes the items that match your criteria.

A list filter tool is available in the menu Remove -> Filter.

Example usage

Imagine you have the following list of products:

• Lenovo IdeaPad 3 11 Chromebook Laptop, 11.6"
• ASUS TUF Dash 15 (2022) Gaming Laptop, 15.6”
• Lenovo Ideapad 3 Laptop, 15.6" HD
• Apple MacBook Air Laptop with M2 chip: 13.6"
• ASUS TUF Gaming F15 Gaming Laptop, 15.6”
• MSI GV15 15.6" 144Hz Gaming Laptop
• ASUS Chromebook C403 Rugged & Spill Resistant Laptop, 14.0"

If you wish to extract the list of available ASUS models:

1. Provide the producer name as a pattern: ASUS.
2. Set the filter type to Leave matches
3. Click the Filter button.

The result will look as follows:

• ASUS TUF Dash 15 (2022) Gaming Laptop, 15.6”
• ASUS TUF Gaming F15 Gaming Laptop, 15.6”
• ASUS Chromebook C403 Rugged & Spill Resistant Laptop, 14.0"

The advanced funcionality

The tool accepts a regular expression as a pattern, so you are not limited to a simple string match, but you could filter a list of items according to complex regex patterns.

When can our tool help you?

1. You are a data analyst who is working with a large dataset and wants to filter out irrelevant data points. You can use the tool to define a pattern that matches the data points you want to remove and then remove them from the dataset.

2. When you want to filter a list of customer reviews to find those that mention a specific product feature, you can use the tool to define a pattern that matches the feature you're looking for and then leave only those reviews that contain that pattern.

3. You are a customer support agent who wants to filter a list of customer complaints to find those that are related to a specific issue. You can use the tool to define a pattern that matches the issue you're investigating and then leave only those complaints that contain that pattern.

4. You are a marketer who wants to filter a list of email addresses to find those that are associated with a specific domain. You can use the tool to define a pattern that matches the domain you're looking for and then leave only those email addresses that contain that pattern.

5. You are a webmaster who wants to filter a list of website URLs to find those that are associated with a specific topic. You can use the tool to define a pattern that matches the topic you're interested in and then leave only those URLs that contain that pattern.

6. You are an e-commerce owner who wants to filter a list of sales transactions to find those that meet specific criteria. You can use the tool to define a pattern that matches the criteria you're looking for, such as a minimum order amount or a specific product SKU, and then leave only those transactions that contain that pattern.

7. You are a marketer who wants to filter a list of social media mentions to find those that contain specific keywords. You can use the tool to define a pattern that matches the keywords you're interested in and then leave only those mentions that contain that pattern.

8. You are a recruiter who wants to filter a list of job applicants to find those who meet certain qualifications. You can use the tool to define a pattern that matches the qualifications you're looking for, such as a specific degree or certification, and then leave only those applicants that contain that pattern.

9. You are a marketer who wants to filter a list of website visitor data to find those who meet certain criteria, such as those who have visited a specific page or spent a minimum amount of time on the site. You can use the tool to define a pattern that matches the criteria you're looking for and then leave only those visitors that contain that pattern.

10. You are a data analyst who wants to filter a list of shop visitors to find those that are associated with a specific demographic or geographic location. You can use the tool to define a pattern that matches the demographic or location you're interested in and then leave only those that match that pattern.

11. You are a surveyor who wants to filter a list of survey responses to find those that answer a specific question or set of questions in a certain way. You can use the tool to define a pattern that matches the question or questions you're interested in and then leave only those responses that contain that pattern.

Similar tools

For specific needs, PicoToolkit provides a set of built-in tools. In the Extract tab, you can find tools for extracting URLs, emails, phone numbers, unique words, etc.