Filemaker Pro 8.5 Educational Maintenance T2 TJ085LL/A 사용자 설명서
제품 코드
TJ085LL/A
Chapter 12
|
Text functions 163
Exact
Format
Exact(originalText;comparisonText)
Parameters
originalText - any
, text
comparisonText - any text expression, text field, or container field
Data type returned
number
Description
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
lowercase usage must be the same. If the fields match, the result is
1
(True); otherwise
the result is
0
(False). For container fields, the data must be stored in the same manner
(either embedded, or stored by file reference).
Note
When evaluating values, text attributes such as font, styles, and sizes are not
considered.
Tip
If case isn't important, use the Lower or Upper function on both parameters to
process data before checking for an exact match.
Examples
Exact(“McDonald”;“McDonald”) returns
1
(True).
Exact(“McDonald”;“MCDONALD”) returns
0
(False).
Exact(Upper(“McDonald”);Upper(“MCDONALD”)) returns
1
(True).
Exact(“John”;“John ”) returns
0
(False).
Exact(BillTo;ShipTo) returns
1
(True) when the value in BillTo is the same as the
value in ShipTo.
Exact(Recipient;Upper(Recipient)) returns
1
(True), when Recipient contains
“JOHNSON”
Exact(Country;“Spain”) returns 1 (True) when the Country field contains
Spain
.
A count of the total number of values in the specified text.
A count of the total number of words in the specified text.
This function
Returns