Filemaker Pro 9 (120)

Question 1

This set entered on 8-3-14
8.3.14.1
WORD FUNCTIONS

1. In FileMaker’s mind, what is a word?

Answer 1

it is any stretch of letters, numbers, or periods that does not have any other spaces or punctuation in it, thus most of the time FileMaker can see the real words in the text.

Question 2

2. These are words: FileMaker, ABC123, This.is.a.word. These are not a word:

Answer 2

FileMaker Pro, ABC 123, A-Test, Two***Words. All these are TWO words.

Question 3

3. FileMaker has THREE word oriented functions called:

Answer 3

LeftWords, RightWords, and MiddleWords. Each takes two parameters, including the text value to examine, and a number or two to tell Filemaker which words you’re interested in.

Question 4

4. What does the LeftWords function look like?

Answer 4

LeftWords ( text ; numberOfWords )

Question 5

5. What are the LeftWords, MiddleWords, and RightWords useful for?

Answer 5

You can use them to PARSE a person’s first and middle name if you ever get a file with all three names dumped into a single field.

Question 6

6. What would this function return: LeftWords ( Preamble ; 3 ) ?

Answer 6

We the People

Question 7

7. What if the Preamble contained ThisIsa***test, what would the function LeftWords ( Preamble ; 3 ) return?

Answer 7

ThisIsA. It doesn’t just return the words, it returns EVERYTHING before the END OF THE THIRD WORD.

Question 8

8. What would RightWords ( Revelations ; 1 ) return?

Answer 8

Amen