Case Sensitive values in Smart Lists | Community
Skip to main content
A
Anonymous
March 26, 2014
Question

Case Sensitive values in Smart Lists

  • March 26, 2014
  • 3 replies
  • 1850 views
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.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Aqeel_Akbar
Aqeel_Akbar
Level 4
October 8, 2014
We're having the same issue, any updates on this?
A
Anonymous
October 8, 2014
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
Aqeel_Akbar
Level 4
October 8, 2014
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.
Terms & ConditionsAccessibility statement

Loading footer...