Attention: The Marketo Community will undergo scheduled maintenance on Tuesday, August 20th between 10-11 PM PDT. During this time, the Community and its content will not be accessible. We apologize for any inconvenience this may cause.
So here's the situation:
I hope you were able to follow along. Hoping someone has an idea they can share on how to achieve this.
Thanks!
Danielle
Surround the list of values with an extra delimiter.
That is, instead of
Primary Contact,ABC Primary Contact
use
,Primary Contact,ABC Primary Contact,
Then a filter on [contains]
,Primary Contact,
finds an exact match on only that inner value.
This is an age-old programming technique that should be used for delimited strings.
This is awesome
I still remember the first time I saw this used in a SQL VARCHAR column ages ago and had the a-ha! moment.
You are amazing
Thanks Sanford for that great idea! How would I surround it by a delimiter? I'm guessing that would have to be programmed in SFDC since this is an SFDC custom field.
If it's coming from SFDC then it'd be best to do it there.
But you could also use Change Data Value on the Marketo side: if the current value doesn't start with "," then add "," at beginning and "," at the end.
Do you have any tips on how to do it in SFDC? I couldn't find any good resources in my search, but maybe I'm not using the right keywords to find the solution. Thanks Sanford!