Need to find specific data in a field using a calc

[Tony Martin]

Hi gang. Currently I'm forced to use 5.5v1 for this project.

THE SITUATION:

What I have is a field named _OWNER1 that contains rather long strings of text (owners names). In my calculation field named _CALC_corpown I need a YES or NO result if the _OWNER1 field contains an instance of " CORP " or " CORPORATION".

THE PROBLEM:

The text strings within _OWNER1 for each record (and thus, the location of " CORP " or " CORPORATION) vary greatly and look like these (as examples):

ACE SECURITIES CORP LLAMA LOAN TR

INTERNATIONAL LLAMA CORPORATION OF AMERICA

LLAMALAND CORP

THE CORP OF LLAMA MANAGEMENT INC

...etc etc etc.

THE QUESTION:

Does anyone have a suggestion as to how I might go about finding the specific text from within my formula so as to get the YES (it exists) or NO (it ain't there) result?

THANK YOU IN ADVANCE!

Tony

(P.S. - No llamas were injured in the making of this post.)

[Raybaudi]

Hi

I don't remember... there isn't PatternCount ( ) in v 5.5 ?

Because, if it exists, you can use this calc:

Case(

PatternCount ( _OWNER1 ; "Corp" ) ; "YES" ;

"NO"

)

[Tony Martin]

This worked fine - thank you!