Page 1 of 1

If field includes this text in it...

PostPosted: Fri May 12, 2006 1:42 pm
by Nate
Stumped on another seemingly simple one...

Need to determine if a field *includes* a particular word or phrase.

I've got a field "Needs" that is filled by designating it as a checkbox set.

I've got a script that is going to create solution recommendations based on whether particular needs are selected in the "Needs" field.

I want my script to evalute that field, and IF it includes the designated word/phrase, or the designated combination (more than one) word/phrase, then it would complete complete the functions of the script.

We're not talking an exact match here, but whatever combination I designate.

?

Nate

PostPosted: Fri May 12, 2006 2:04 pm
by John Sindelar
I think Patterncount() will do what you want. You might also check out FilterValues(). I think the syntax for the Filter... functions is a little simpler if your looking for a match on any or all of several items.