D toc |
---|
Excerpt |
---|
Returns |
D s | ||
---|---|---|
|
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 | ||
---|---|---|
|
D code |
---|
derive type:single value:EXACT(string_ref1,string_ref2) |
Argument | Required? | Data Type | Description |
---|---|---|---|
string_ref1 | Y | string | Name of first column or first string literal to apply to the function |
string_ref2 | Y | string | Name 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 snippet usage
Required? | Data Type | Example Value |
---|---|---|
Yes | String literal, column reference, or expression evaluating to a string | myString1, myString2 |
D s | ||
---|---|---|
|
Example - Simple string comparisons
Include Page EXAMPLE - String Comparison Functions EXAMPLE - String Comparison Functions
D s also label string