I have a text field.
If the text field contains a certain word or phrase I want a number field to display a pre defined number.
I was looking at the if functions but couldn't find the right one
The "PatternCount()" function returns the number of occurrences of a word/phrase in a text (field or variable).
If you don't need the actual number of occurrences, a test:
If ( PatternCount( text ; searchPhrase )
Would return true for 1 or more and false of 0. And would show you just IF there is a pattern match or not.
Thanks again Beverly. Ill give it a try
Retrieving data ...