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

Featured Replies

Any time the FM help references word functions there is this statement:

Note The ampersand (&) and hyphen (-) characters identify the beginning of a new word.

What does this mean? I am trying to breakdown a phone number where the elements of the number are separated by hyphens, but wordcount returns a value of 1. I find the help confusing especially since I would assume that spaces identify the beginning of a new word.

In version 7, the hyphen is NOT considered as a word delimiter IF it is between two numbers:

"m-n" is 2 words.

"m-2" is 2 words.

"1-n" is 2 words.

"1-2" is 1 word.

Try using Substitute() to work around that, e.g.B)

Let (

phone = Substitute ( PhoneField ; "-" ; " " ) ;

<< rest of your calc using "phone" instead of the field's name >>

  • Author

Thanks for the useful tip. That helped a lot.

:thumbdown: It would be nice it that was documented in the Help (it may be there but it is not obvious.)

It would be nice it that was documented in the Help

Yes it would. That's assuming they did this on purpose, or at least knew about this. I have a vague suspicion it's just an unintended by-product of providing the Evaluate() function.

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.