August 19, 200520 yr 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.
August 19, 200520 yr 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 >>
August 20, 200520 yr Author 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.)
August 20, 200520 yr 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