Filter Rows for Exact Word Matches in Data Analysis

·Jul 09, 2025 06:19 PM·

is there a way to filter on rows containing exactly a word. Like when I try to filter on rows containing "DE", it also give me something like Netherlands but I just need the rows where it says "DE" and nothing else

5 comments

· Sorted by Oldest

Clay
APP
·
·
Use the "equal to" operator instead of "contains" when filtering. To filter for exactly "DE": 1. Click Filter above your table 2. Select your column 3. Choose "equal to" as the operator 4. Enter "DE" as the value The "equal to" operator checks if text matches the specified value exactly, while "contains" finds any cells that include your search term as a substring.
Sources: Comparison operators | Documentation | Clay University Customize your table view | Documentation | Clay University Hide, Re-order, Sort, Filter, Merge Columns
LuisArturo
·
·
Hey there David thanks for reaching out, yes this can be done using our Filter option, you can chose to set it so that the filter checks to see if the "Location" column either contains or is equal to a specific value
(68 kB)
David K.
·
·
And how can I create a checkmark that is only checked to the rows in this specific view?
Clay
APP
·
·
Hi David - jumping in for LuisArturo here. For this, you can use a formula column to return true in for all row entires, and this will generate the checkboxes for you here. You can see a video of this here: https://www.loom.com/share/45e17c33a20641068436172f26287528?sid=3fac5904-487a-4d57-859d-a1f9de3efad1
Clay
APP
·
·
Hope that helps and let us know if you have any more questions! - Aditi

Clay
APP
·
·
Use the "equal to" operator instead of "contains" when filtering. To filter for exactly "DE": 1. Click Filter above your table 2. Select your column 3. Choose "equal to" as the operator 4. Enter "DE" as the value The "equal to" operator checks if text matches the specified value exactly, while "contains" finds any cells that include your search term as a substring.
Sources: Comparison operators | Documentation | Clay University Customize your table view | Documentation | Clay University Hide, Re-order, Sort, Filter, Merge Columns
LuisArturo
·
·
Hey there David thanks for reaching out, yes this can be done using our Filter option, you can chose to set it so that the filter checks to see if the "Location" column either contains or is equal to a specific value
(68 kB)
David K.
·
·
And how can I create a checkmark that is only checked to the rows in this specific view?
Clay
APP
·
·
Hi David - jumping in for LuisArturo here. For this, you can use a formula column to return true in for all row entires, and this will generate the checkboxes for you here. You can see a video of this here: https://www.loom.com/share/45e17c33a20641068436172f26287528?sid=3fac5904-487a-4d57-859d-a1f9de3efad1
Clay
APP
·
·
Hope that helps and let us know if you have any more questions! - Aditi