Wordcount function?

[PatriciaW]

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.

[comment]

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.

Let (

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

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

[PatriciaW]

Thanks for the useful tip. That helped a lot.

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

[comment]

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.