EXAMPLE - String Comparison Functions
This example demonstrates functions that can be used to compare two sets of strings.
Functions:
Item | Description |
---|---|
STRINGGREATERTHAN Function | Returns |
STRINGGREATERTHANEQUAL Function | Returns |
STRINGLESSTHAN Function | Returns |
STRINGLESSTHANEQUAL Function | Returns |
EXACT Function | Returns |
Source:
The following table contains some example strings to be compared.
rowId | stringA | stringB |
---|---|---|
1 | a | a |
2 | a | A |
3 | a | b |
4 | a | 1 |
5 | a | ; |
6 | ; | 1 |
7 | a | a |
8 | a | aa |
9 | abc | x |
Note that in row #6, stringB
begins with a space character.
Transformation:
For each set of strings, the following functions are applied to generate a new column containing the results of the comparison.
Transformation Name | |
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | STRINGGREATERTHAN(stringA,stringB) |
Parameter: New column name | 'greaterThan' |
Transformation Name | |
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | STRINGGREATERTHANEQUAL(stringA,stringB) |
Parameter: New column name | 'greaterThanEqual' |
Transformation Name | |
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | STRINGLESSTHAN(stringA,stringB) |
Parameter: New column name | 'lessThan' |
Transformation Name | |
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | STRINGLESSTHANEQUAL(stringA,stringB) |
Parameter: New column name | 'lessThanEqual' |
Transformation Name | |
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | EXACT(stringA,stringB) |
Parameter: New column name | 'exactEqual' |
Results:
In the following table, the Notes
column has been added manually.
rowId | stringA | stringB | lessThanEqual | lessThan | greaterThanEqual | greaterThan | exactEqual | Notes |
---|---|---|---|---|---|---|---|---|
1 | a | a | true | false | true | false | true | Evaluation of differences between |
2 | a | A | true | true | false | false | false | Comparisons are case-sensitive. Uppercase letters are greater than lowercase letters. |
3 | a | b | true | true | false | false | | Letters later in the alphabet (b) are greater than earlier letters (a). |
4 | a | 1 | false | false | true | true | | Letters (a) are greater than digits (1). |
5 | a | ; | false | false | true | true | false | Letters (a) are greater than non-alphanumerics (;). |
6 | ; | 1 | true | true | false | false | false | Digits (1) are greater than non-alphanumerics (;). Therefore, the following characters are listed in order of evaluation: Aa1; |
7 | a | a | false | false | true | true | false | Letters (and any non-breaking character) are greater than space values. |
8 | a | aa | true | true | false | false | false | The second string is greater, since it contains one additional string at the end. |
9 | abc | x | true | true | false | false | false | The second string is greater, since its first letter is greater than the first letter of the first string. |