Filtering for words/letters isolated in Flow Data Value Change

Forum|Forum|9 years ago
February 10, 2017
2 replies
3026 views

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.

Thank you

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Devraj_Grewal

Level 10

Robert,

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.