| 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. |
String literal reference example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:exact('a','a') as:'stringExactCompare' |
|---|
|
exact('a','a') |
Output: Returns true, since the values are identical.
String literal reference example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:exact('a','A') as:'stringExactCompare' |
|---|
|
exact('a','A') |
Output: Returns false, since the capitalization is different between the two strings.
Column reference example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:exact(string1,string2) as:'stringExactCompare' |
|---|
|
exact(string1,string2) |
Output: Returns the evaluation of string1 column values being exact matches with the corresponding string2 column values.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:exact(string_ref1,string_ref2) |
|---|
|
exact(string_ref1,string_ref2 [,ignore_case]) |
| 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 |
| ignore_case | N | string | When true, matching is case-insensitive. Default is false. |
string_ref1, string_ref2
String literal, column reference, or expression whose elements you want to compare based on this function.
| Required? | Data Type | Example Value |
|---|
| Yes | String literal, column reference, or expression evaluating to a string | myString1, myString2 |
ignore_case
When true, matches are case-insensitive. Default is false.
| Info |
|---|
NOTE: This argument is not required. By default, matches are case-sensitive. |
| Required? | Data Type | Example Value |
|---|
| No | String literal evaluating to a Boolean | 'true' |
Example - Simple string comparisons
| Include Page |
|---|
| EXAMPLE - String Comparison Functions |
|---|
| EXAMPLE - String Comparison Functions |
|---|
|
