EXACT function

EXACT(text1, text2) EXACT(text1; text2)

text1 — Text or { Text }

The first text string to test.

text2 — Text or { Text }

The second text string to test.

Returns — Logical or { Logical }

Whether the given text strings are identical, taking into account case.

Returns whether the two text strings are identical, in terms of content and in terms of case. EXACT("ab", "AB")EXACT("ab"; "AB") returns FALSE, because the comparison is done in a case-sensitive manner. "ab" = "AB""ab" = "AB", however, returns TRUE, because the = operator is not case-sensitive.

EXACT exists primarily to perform case-sensitive text comparisons. The Calcapp-specific operator == is also case-sensitive, meaning that "ab" == "AB""ab" == "AB" returns FALSE.

Examples

EXACT("ab", "AB")EXACT("ab"; "AB")

Returns FALSE, because the comparison is done in a case-sensitive manner.

"ab" = "AB""ab" = "AB"

Returns TRUE, because the = operator is not case-sensitive.

"ab" == "AB""ab" == "AB"

Returns FALSE, because the == operator is case-sensitive.

EXACT({ "ab", "test" }, { "AB", "test" })EXACT({ "ab"; "test" }; { "AB"; "test" })

Returns the array { FALSE, TRUE }{ FALSE; TRUE }. The first element is FALSE because "ab" and "AB" are not considered identical by EXACT due to the case-sensitive text comparison. The second element is TRUE, because "test" and "test" are considered identical.