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.
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.
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.
.png)
Adchoices