Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Need to find specific data in a field using a calc

Tony Martin
in The Left Brain

Featured Replies

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.)

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"

)

  • Author

This worked fine - thank you!

Create an account or sign in to comment

https://fmforums.com/topic/47691-need-to-find-specific-data-in-a-field-using-a-calc/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.