Filemaker Pro 9 (122)

Question 1

This set entered on 8-3-14
8.3.14.3

1. What does the SUBSTITUTE Function do?

Answer 1

It performs a Find and Replace WITHIN a text value.

Question 2

2. How would you write a function to replace all the NO with YES on a field?

Answer 2

Substitute ( Buy ; “No” ; “Yes” ). Buy, in this case, is a FIELD that tells you whether you should buy
something or not.

Question 3

3. A few FileMaker functions support a special BRACKETED SYNTAX and Substitute is one of them. This means that if you want to:

Answer 3

Perform several REPLACEMENTS on a piece of text, you can do it with one SUBSTITUTE FUNCTION.

Question 4

4. For example, how do you remove all the vowels from a field?

Answer 4

Substitute ( My Field ; [“a” ; “ “] ; [“e” ; “ “] ; [“i” ; “ “] ; [“i” ; “ “] ; [“o” ; “ “] ; [“u” ; “ “]

Question 5

5. What does the Filter Function do?

Answer 5

It can remove anything that you DON’T specify.

Question 6

6. How would you remove any non-numeric characters from a credit card number?

Answer 6

Filter ( Credit Card Number ; “0123456789” )

Question 7

7. What will this function return: Filter ( Task ; “to do” ) ?

Answer 7

It will return all the t’s, the o’s, and the d’s. It will not know to return “to do” only.