Why not concatenate the values with a ; (and also add a ; at beginning and end) and then use a [contains] filter? I'm not seeing why the values need to be split permanently here.
Thanks for your reply. I think you are right, even split wont help.
Here is the scenario:
I have contact named "Rajesh" in SFDC he has 4 leads. Now my main field in SFDC "ALL FIELDS" contains all these 4 leads:
SFDC LEAD ID, LEAD STATUS, DEAD REASON
1. 00162727ERT, DEAD, NO PRODUCT REQUIREMENT
2. 00132754WEQ, IN PROGRESS
3. 001215423POI, NEW
4. 00892727NMT, DEAD, NO PRODUCT REQUIREMENT
Now the above field is a text field and I just want to delete two Leads which are Dead, those are Number 1 and 4.
How can I pickup these two leads and send for deletion?
Get a CSV with all the lead IDs that you want to purge (column 1) and the status and reason (columns 2, 3).
Import the CSV using the Marketo REST Bulk Import API, using SFDC Lead ID as the dedupe key. Then run a Smart List to delete the leads.