Case Sensitive values in Smart Lists

Anonymous
Not applicable

Case Sensitive values in Smart Lists

Is there a way to specify case sensitive values in a smart list? Specidically, I'm cleaning up data values in a Marketo field. The values are:

"Not evaluating" and "Not Evaluating".

I have a smart list looking at a field whose values are "Not Evaluating". The results are including values that are "Not evaluating" and I don't want it to. (Note letter casing for items in quotes"

I'm trying to make all of them say "Not evaluating", making the "e" in lower case.
Tags (1)
3 REPLIES 3
Aqeel_Akbar
Level 4

Re: Case Sensitive values in Smart Lists

We're having the same issue, any updates on this?
Anonymous
Not applicable

Re: Case Sensitive values in Smart Lists

My hack solution for this was to make an Operationl Manual Smart Campaign

If purchase_timeframe="not evaluating" then purchase_timeframe="Not evaluating"

This will ring true for all capitalization values for that field and hard change them to the right capitalization. It's an expensive database update to all records but a one time deal provided that you've updated all your forms to use the right capitalization. Run it at night.
Aqeel_Akbar
Level 4

Re: Case Sensitive values in Smart Lists

Wondering if there is a scalable solution for this? There are lots of String values that get generated in Salesforce that we want to filter on and are case sensitive.