EXACT function
This topic describes the formula syntax and usage of the EXACT function in the Data Quality Execute Formula transform.
Description
Checks to see if two text values are identical. Returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive.
Syntax
EXACT(text1,text2)The EXACT function syntax has the following arguments:
- text1 Required. The first text string.
- text2 Required. The second text string.
Example
| First_String | Second_String | Formula | Description | Result |
|---|---|---|---|---|
| Apples | Apples | EXACT([First_String],[Second_String]) |
Checks whether two identical strings match. | TRUE |
| Apples | apples | EXACT([First_String],[Second_String]) |
Checks whether same string with different capitalization matches. | FALSE |
| Apples | Oranges | EXACT([First_String],[Second_String]) |
Checks whether two different strings match. | FALSE |