I am creating a flow that updates a Persona field for new leads coming into the database based on Job Titles that include "IT" using the IF "Job Title" contains. Is it possible using either "", [ ], or ** to just filter when IT is isolated? Otherwise I pull in words like "Auditor", "Architect", "Litigation", "Quality".
The only thing I can think of is using IF "Job Title" contains AND "Job Title" NOT CONTAIN and have to think of all the different Job Titles that have "it" in them.
You could use "if job title contains " IT " and include the spaces. That will require "IT" to be a word on it's own. I would first query your database to exclude any other job titles that may include " IT " but would not be appropriate (ex. "Executive Assistant to the IT Director"). Then you can also bring in the filter of "job title does not contain" and list all of the exceptions to the rule.
You're right, it will trim the space before the "IT" but the ending space remains (ex. "IT "). That should help a bit to begin with.
OK this does help a bit but doesn't filter out words like "credit" so still not useful to me. Perhaps I should open a future request for this. Appreciate you helping me out Devraj.
You can create a persistent space-padded (on both sides) string in a Smart List using the same method used to inject line breaks here: http://blog.teknkl.com/dark-mkto-alleys-line-break-token/
I am sure you have it all figured out by now. In case, you are looking for some more alternatives, there's a 'webhooks' approach you can use.
Or Google 'Marketo Wild Card'
This involves using this DIY webhooks library for Marketo - Marketo LaunchPoint – Marketo LaunchPoint
How to use?