August 27, 200718 yr 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.
Create an account or sign in to comment