I’m trying to do an active list with all job titles containing exactly the word “AI”, like for instance :
- Head of AI
- AI Director
The issue is when I make an active list, I can only select “Contains any of AI” which is going to list all contacts with job titles containing “AI”, but with job titles like :
- Marketing Campaign Director
- Main Product Director
=> which is not at all what I’m looking for.
However, I am able to use the right filtering in Views. In there, I can filter with “Job title contains exactly: AI”, which is listing all the contacts with the job titles I am looking for.
It would be great to have consistent behavior and have the same filter in Lists.
There was a recent change where you can’t filter contacts in the contacts page by “contains X”, therefore we can’t filter contacts properly without going to lists (which are very slow).
Would love if yuo just took it back to the way it was before, or make it easy to filter.
Example: Filter all contacts that have the area code 12 in their phone numbers.
I’m told by Hubspot support that the current behavior for this operator which is actually “contains all” is by design. I request that you add a new operator named “contains all” and give us a true “contains exactly” option.
For example, if I search for contains exactly “IT Services for business” in the description. I get results where the description reads:
“Business solution for IT Services”
When the product I’m looking for has the description:
You would think using “contains exactly” in Views would be a workaround but no. Apparently, Views treats “contains exactly” differently than lists (segments) do. This according to HubSpot chat:
“What you’re seeing is expected behavior of “contains exactly” in Views. The operator treats non‑alphanumeric characters as delimiters and ignores them for matching. Even with quotes, punctuation like underscores, slashes, or pipes are treated like spaces, so strings that look “similar” can still match if the same words appear in order. HubSpot also matches case‑insensitively in this context.”
Hello! My name is Hallie, and I’m a Program Manager on the CXM Team. I’m excited to share that this feature is now available! In lists, workflows, and advanced filters, you’ll see an option for ‘contains exactly’ as well as ‘doesn’t contain exactly’ for string-based properties. This is available for all Hubs and Tiers.
Sounds good but in my example…will it recognize the WORD AI or still think AI as two letters? Not clear. Sorry if I am missing something in your update. An example in my case is creating a segment with the word AI in their Job Title. I dont want to include contacts with the LETTERS A, I
@BillX it appears that the filter strictly looks for the lone word, “AI”. For example, “Kai” would not pass the example filter, but “director of ai” would.
@hhiggins Will there ever be the option to search for contacts by matching substring of a property string value? For example, I have contacts by First Name “John” and “Josephine”, and I search against the First Name field for substring “jo”, matching with these two contacts. Is there (or will there be) an option for these to be filtered? Is there currently a way to run the same search / filter via the api?
