Reference > Functions reference > Text functions > Exact
 

Exact

Returns 1 (true) if the contents of any two fields match; otherwise, returns 0 (false).

Format 

Exact ( originalText ; comparisonText )

Parameters 

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

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

Data type returned 

number

Originated in version 

6.0 or earlier

Description 

For text to match exactly, the uppercase and lowercase usage must be the same. For container fields, the data must be stored in the same manner (either embedded, or stored by reference).

Notes 

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

If case isn't important, use the Lower function or Upper function on both parameters to process data before checking for an exact match.

Example 1 

Exact ( "McDonald" ; "McDonald" ) returns 1 (True).

Exact ( "McDonald" ; "MCDONALD" ) returns 0 (False).

Exact ( "John" ; "John " ) returns 0 (False).

Example 2 

Exact ( Upper ( "McDonald" ) ; Upper ( "MCDONALD" ) ) returns 1 (True).

Example 3 

Exact ( BillTo ; ShipTo ) returns 1 (True) when the value in BillTo is the same as the value in ShipTo.

Example 4 

Exact ( Recipient ; Upper ( Recipient ) ) returns 1 (True), when Recipient contains JOHNSON.

Example 5 

Exact ( Country ; "Spain" ) returns 1 (True) when the Country field contains Spain.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas