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.

Word Count in Fields

Featured Replies

Hello,

I am trying to do a count of how many times a Certain word appears in a text field. I would like to count how many times "Suit 1" and "Suit 2" appears in my database, all references would be entered in the same fields, among different records.

Thanks,

Dave

PatternCount ( yourField ; "Suit 1" ) ... will tell you how many times it appears in the field. So create a calculation (result is number) with it.

Do you want result for found set or all records? Then create a Summary field with "Total of" and point to the above calc. This will produce total 'count' of Suite 1 for that set of records.

  • Author

thanks!!

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.