Filemaker Pro 9 (118)

Question 1

This set entered on 8-3-14
8.2.14.7

1. What are TEXT PARSING CALCULATIONS?

Answer 1

Think of PARSING as sifting. These calcs could get data from other database and rearrange the text, pull out email addresses from paragraphs, and in general, slicing and dicing text.

Question 2

2. Fixing data for certain fields, or pulling out data out of certain fields usually entails:

Answer 2

doing a FIND for a certain kind of data and then using the RECORDS–>REPLACE FIELD CONTENTS command.

Question 3

3. In contrast to the wide variety of mathematical OPERATORS for working with numbers, there is only one for working with text:

Answer 3

CONCATENATION OPERATOR (&). It strings bits of text together.

Question 4

4. What does the CONCATENATION OPERATOR do?

Answer 4

It lets you combine text from two different fields and make them work better together.

Question 5

5. What calc would you use to show First Name and Last Name in a field, when the Person ID will only show either First or Last Name?

Answer 5

Create a NEW FIELD and add this calc: Last Name & “, “ & First Name. The results would be something like “Jean, Norma” or “Nesbitt, Mike”