Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc
Excerpt

Returns true if the second string evaluates to be an exact match of the first string. Source values can be string literals, column references, or expressions that evaluate to strings.

D s
snippetBasic

String literal reference example:

D code

derive type:single value:EXACT('a','a') as:'stringExactCompare'

Output: Generates true in the new column stringExactCompare, since the values are identical.

String literal reference example:

D code

derive type:single value:EXACT('a','A') as:'stringExactCompare'

Output: Generates false in the new column stringExactCompare, since the capitalization is different between the two strings.

Column reference example:

D code

derive type:single value:EXACT(string1,string2) as:'stringExactCompare'

Output: Generates a new stringExactCompare column containing the evaluation of string1 column values being exact matches with the corresponding string2 column values.

D s
snippetSyntax

D code

derive type:single value:EXACT(string_ref1,string_ref2)

ArgumentRequired?Data TypeDescription
string_ref1YstringName of first column or first string literal to apply to the function
string_ref2YstringName of second column or second string literal to apply to the function

D s lang notes

string_ref1, string_ref2

String literal, column reference, or expression whose elements you want to compare based on this function.

D s
snippetusage

Required?Data TypeExample Value
YesString literal, column reference, or expression evaluating to a stringmyString1, myString2


D s
snippetExamples

Example - Simple string comparisons

Include Page
EXAMPLE - String Comparison Functions
EXAMPLE - String Comparison Functions

D s also
labelstring