Filemaker Pro 9 (113)

Question 1

This set entered on 8-3-14
8.2.14.2

REPLACING DATA USING CALCULATION 1. When you use the RECORDS–>REPLACE FIELD CONTENTS command, you are telling FileMaker to:

Answer 1

visit every record IN THE FOUND SET, and replace the contents of ONE FIELD WITH SOMETHING NEW.

Question 2

2. Using the

RECORDS–>REPLACE FIELD command, you can:

Answer 2

enter a single value in every record in the found set, OR USE A CALCULATION TO FIGURE OUT WHAT SHOULD GO IN EACH RECORD.

Question 3

3. Suppose you never capitalized the city names, and now you realize they should all be capitalized. How do you do this?

Answer 3

You use the REPLACE FIELD CONTENTS Command, using the PROPER Function.

Question 4

4. What does the PROPER Function do?

Answer 4

It capitalizes the first letter of each word it encounters.

Question 5

5. How do you use the PROPER Function?

Answer 5

Choose the FIELD YOU WANT TO CAPITALIZE. Choose RECORDS–>REPLACE FIELD CONTENTS and select “Replace With Calculated Result” and the SPECIFY CALCULATION window opens.

Question 6

6. When the SPECIFY CALCULATION window opens, you choose:

Answer 6

in the TEXT FUNCTIONS the “Proper ( text )” function. You select the FIRST NAME as the PARAMETER, click OK.