Date: Mon, 17 Jan 2022 22:53:13 +0000 (GMT) Message-ID: <1737092368.105384.1642459993163@9c5033e110b2> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_105383_560271325.1642459993163" ------=_Part_105383_560271325.1642459993163 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html EXAMPLE - String Comparison Functions

EXAMPLE - String Comparison Functions

This example demonstrates functions that can be used to compare two= sets of strings.

Functions:

=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Item Description
STRINGGREATERTHAN Function Returns true if the first st= ring evaluates to be greater than the second string, based on a set of comm= on collation rules.
STRINGGREATERTHANEQUAL Function Returns true if the first st= ring evaluates to be greater than or equal to the second string, based on a= set of common collation rules.
STRINGLESSTHAN Function Returns true if the first st= ring evaluates to be less than the second string, based on a set of common = collation rules.
STRINGLESSTHANEQUAL Function Returns true if the first st= ring evaluates to be less than or equal to the second string, based on a se= t of common collation rules.
EXACT Function Returns true if the second s= tring evaluates to be an exact match of the first string. Source values can= be string literals, column references, or expressions that evaluate to str= ings.

Source:

The following table contains some example strings to be compared. <= /p>

=20 =20 =20 =20
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 chara= cter.

Transformation:

For each set of strings, the following functions are applied to generate= a new column containing the results of the comparison.

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula STRINGGREATERTHAN(stringA,stringB)<= /td>=20 'greaterThan'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula STRINGGREATERTHANEQUAL(stringA,stringB) 'greaterThanEqual'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula STRINGLESSTHAN(stringA,stringB)=20 'lessThan'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula STRINGLESSTHANEQUAL(stringA,stringB) 'lessThanEqual'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula EXACT(stringA,stringB) 'exactEqual'
=20

Results:

In the following table, the Notes column has been adde= d manually.

=20 =20 =20 =20 =20 =20 =20 =20 =20
rowId stringA stringB lessThanEqual lessThan greaterThanEqual greaterThan exactEqual Notes
1 a a true false true false true Evaluation of differences between = STRINGLESSTHAN and STRINGGREATERTHAN and greater = than versions.
2 a A true true false false false Comparisons are case-sensitive. Uppercase letter= s are greater than lowercase letters.
3 a b true true false false false
Letters later in the alphabet (b) are greater th= an earlier letters (a).
4 a 1 false false
true true false
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 follow= ing characters are listed in order of evaluation:

=20
Aa1;
= =20
7 a  a false false true true false Letters (and any non-breaking character) are gre= ater 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 le= tter is greater than the first letter of the first string.

=20
=20

= =20

=20
• =20
=20 Page:= =20
=20
=20 EXACT Function= =20
• =20
• =20
=20 Page:= =20
=20
• =20
• =20
=20 Page:= =20
=20
• =20
• =20
=20 Page:= =20
=20
• =20
• =20
=20 Page:= =20
=20
• =20
=20

=20
=20
=20

------=_Part_105383_560271325.1642459993163--