Справочник Пользователя для Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A

Chapter 12

  

|

  Text functions     163

Exact(originalText;comparisonText)

originalText - any 

, text 

comparisonText - any text expression, text field, or container field

number

Compares the contents of any two fields. For text to match exactly, the uppercase and 
lowercase usage must be the same. If the fields match, the result is 

 (True); otherwise 

the result is 

 (False). For container fields, the data must be stored in the same manner 

(either embedded, or stored by file reference).

When evaluating values, text attributes such as font, styles, and sizes are not 

considered. 

If case isn't important, use the Lower or Upper function on both parameters to 

process data before checking for an exact match.

Exact(“McDonald”;“McDonald”) returns 

 (True).

Exact(“McDonald”;“MCDONALD”) returns 

 (False).

Exact(Upper(“McDonald”);Upper(“MCDONALD”)) returns 

 (True).

Exact(“John”;“John ”) returns 

 (False).

Exact(BillTo;ShipTo) returns 

 (True) when the value in BillTo is the same as the 

value in ShipTo. 

Exact(Recipient;Upper(Recipient)) returns 

 (True), when Recipient contains 

“JOHNSON” 

Exact(Country;“Spain”) returns 1 (True) when the Country field contains 

.

A count of the total number of values in the specified text.

A count of the total number of words in the specified text.