Patterncount

[johnrh]

I need to count the number of times either one word or another is found in a field in each record.

For example say a field contains the text "Front, Back, Left, Right"

I need to know how amny times either "Front" or "Left" turn up in this field in this record. (Obviously 2 in this case!!)

I can use Patterncount() to find either "Front" or "Back" but not I think for both words. Patterncount would the answer 1 for both cases.

I guess I am asking if you can put an "OR" condition in a patterncount statement. Or is there another solution that I am missing (very likely)

Thanks for helping.

[David Jondreau]

Plus sign.

PatternCount(field; "text1") + PatternCount(field; "text2")

[johnrh]

Thanks David

Simple when you know how.

John