Field Content

[nelliott]

I want to perform a script depending on the content of a field. I have tried

IF field1 ="xxx" or field1 ="yyy" or field1 ="zzz"

End IF

But I want the script to perform if "xxx" is also only part of the field content and not an exact match of the contents of the field

Any Ideas?

[DykstrL]

Try This:

If(PatternCount(Field1,"XXX")=1)

do this

[danjacoby]

Almost:

If(PatternCount(field1, "xxx") or field1="yyy" or field1="zzz", "yes", "no")

Or you can substitute for "yes" and "no" with whatever the end results should be.

[nelliott]

Sorry, I should have explained myself better. I need the script to perform if "xxx" or "yyy" or "zzz" etc are only part of the field content and not an exact match of the contents of the field not just "xxx"

[andygaunt]

OK,

then try this. Dan was almost there with

quote:

---

If(PatternCount(field1, "xxx") or field1="yyy" or field1="zzz", "yes", "no")

---

If(PatternCount(field1, "xxx") or PatternCount(field1,"yyy") or PatternCount(field1,"zzz"), "yes", "no")

[nelliott]

Cheers Andy (again!) and everybody else for their input