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.

Finding Uppercase in a field

Featured Replies

How do I find uppercase letters in a field?

any uppercase character.

FMP searches are case insensitive by default. However in FMP 6 and earlier setting the field's sort language to ASCII will make it case sensitive.

Though I haven't tried it with 7/8, try setting the language to Unicode.

  • Author

I want to search for any Upper case character after the first letter. want to find out how many characters are Upper case.

thanks

You might try this ... create a calculation (result is number):

Length ( Filter ( Middle ( text ; 2 ; Length ( text ) ) ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) )

This should produce the number of upper case characters IGNORING the first character (in field called text). Search the calculation field for > 0.

Create an account or sign in to comment

Important Information

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

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.