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.

Find based on first word begins with "A"

ibiubu
in Finding & Searching

Featured Replies

When in find mode, can a search be perfomed that is based on alphabet? For example, find all records where the first word in a field begins with "A"

LR

Yes, it can! smile.gif

However typically, a search by a single letter returns records for which any word in the field (not just the first) begin with the supplied letter.

One of the most common ways I've seen to search for records where only the first word in a field starts with the character in question is to create a stored calc field with the formula LeftWords(yourField, 1) and search on that.

Generally this process is scripted, so the user enters find criteria in the normal way, and clicks on a button for "Find by first word only" and the rest is handled by a script which transfers the criterion to the (hidden) calc field and performs the find.

Even simpler: have the calc field be "Left(yourField, 1)". That way, it only returns the first letter of the first word.

"Once you're idiot-proofed something, someone invents a better idiot."

Create an account or sign in to comment

https://fmforums.com/topic/11707-find-based-on-first-word-begins-with-a/
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.