EXACT

The EXACT function compares two text strings, returning True if they are the same and False otherwise.

Syntax

EXACT(
    text1,
    text2
)

Parameters
  • text1: First text string to compare or name of the column containing the first text strings to compare.
  • text2: Second text string to compare or name of the column containing the second text strings to compare.
Returned value

The EXACT function returns a Boolean.

Additional Information

EXACT is case sensitive, so the comparison of "A" and "a" will return False. It is not sensitive, however, to possible format differences that may exist:

EXACT function: Example of use

If any of the arguments is not a text string, it is converted to text. In this way, EXACT will return the value True if it compares the text string "TRUE" with the Boolean TRUE(), or if it compares the text string "0" (zero) with the number 0.

Examples

In this example we want to find out if the products included in the first column of the table belong to the "UC" category. To do this, the category code is extracted (looking for the blank space and extracting the following two characters) and it is compared with the string "UC":

EXACT function: Example of use

Category
Text
Submitted by admin on Mon, 12/03/2018 - 23:35