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

Format text to show only first word?

Featured Replies

I have a field that typically has a customers first and last name together in this field. I'd like to display just the customers first name or the first word in the field. What is the best way to do this?

Show 1st word <<customer_name>> 

Thanks

It works best to use two fields (nameFirst and nameLast) which is the 'one fact per field' concept.  You can use LeftWords() to set the data in the nameFirst field and RightWords() for nameLast.  Once the data has been split, it is easier down the road to put them together again in various merge configurations.

The initial split, when dealing with people's names, works best if you create calculations and review the data.  The data may need to be adjusted; for example, Mary Anne might be the person's first name or Anne might be their middle.  Or d'Angelo, if using RightWords (combinedName ; 1 ) will improperly give you Angelo.

Viewing all the data as calculations first will save you many headaches.  You may wish to keep the 'combined-name' field until you are sure they are all correct.

It works best to use two fields (nameFirst and nameLast) which is the 'one fact per field' concept.

​Indeed it does (and I should have mentioned this).

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.