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.

PatternCount Question

amypaulsmom
in Calculation Engine (Define Fields)

Featured Replies

I am using the Patterncount feature to find the work "signed" in a description field.

Here is my calculation: PatternCount(FoundDescription, "signed"). This works fine, except that it is only finally exactly the word "signed" - not SIGNED or Signed.

Can I adjust for this easily. I need to find the word Signed in any format within my FoundDescription field.

thanks -

  • Author

Solved my own problem - by looking at the calculation field that I had attached to this field definition.

thaks

Yes PatternCount is case sensitive. One way around it is to make the field all lowercase for the purpose of the comparison:

PatternCount(Lower(fieldname), "signed")

It could have equally as effectively been made uppercase.

Create an account or sign in to comment

https://fmforums.com/topic/14135-patterncount-question/
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.