Date: Wed, 8 Feb 2023 13:06:17 +0000 (UTC) Message-ID: <490536773.184.1675861577139@1323b43bed1d> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_183_383747116.1675861577139" ------=_Part_183_383747116.1675861577139 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html STRINGGREATERTHAN Function

# STRINGGREATERTHAN Function

=20

Contents:

=20

=20

=20
=20

Returns `true` if the first string evaluates to be = greater than the second string, based on a set of common collation rules. <= /span>

Source values can be string literals, column references, or expres= sions that evaluate to strings.

Wrangle vs. SQL: This function is part of Wrangle , a proprietary data transformation languag= e. Wrangle is not SQL. For more information,= see Wrangle Language.

## Ba= sic Usage

=20

String literal reference example:

=20

stringgreaterthan(&apos;a&apos;,&a= mp;apos;b&apos;)

Ou= tput: Returns ```fal= se``` since `a` e= valuates to be less than `b.`

``` String literal reference example:=20 stringgreaterthan(&apos;a&apos;,&a= mp;apos;ab&apos;) Ou= tput: Returns fal= se  since the second string contains an additional letter. String literal reference example:=20 stringgreaterthan(&apos;abc&apos;,= &apos;x&apos;) Ou= tput: Returns fal= se since the first letter of the first string is less than the = first letter of the second string. Column reference example:=20 stringgreaterthan(string1,string2)<= /p> Ou= tput: Returns the evaluation of string1 column values being greater than string2 column values. Collation refers to the organizing of written con= tent into a standardized order. String comparison functions utilize collati= on rules for Latin. A summary of the rules: Comparisons are case-sensitive. Uppercase letters are greater than lowercase versions of the same lette= r. However, lowercase letters that are later in the alphabet are greater t= han the uppercase version of the previous letter. Two strings are equal if they match identically. If two strings are identical except that the second string contains one= additional character at the end, the second string is greater. A normalized version of a letter is the unaccented, lo= wercase version of the letter. In string comparison, it is the lowest value= of all of its variants. a is less than =C4=83. However, when compared to b, a =3D =C4=83. The set of Latin normalized characters contains more than 26 characters= . This table illustrates some generalized rules of Latin collation. =20 =20 =20 =20 =20 Order Description Lesser Example Greater Example 1 whitespace (space) (return) 2 Punctuation ' @ 3 Digits 1 2 4 Letters a A 5   A b Resources: NOTE: In the following set of charts (linked below), th= e values at the top of the page are lower than the values listed lower on t= he page. Similarly, the charts listed in the left nav bar are listed in asc= ending order. For more information on the applicable collation rules, see http://www.unicode.org/charts/collation/.    =20 =20 See Also for String Collation Rules:=20 =20 =20 Page:<= /span>=20 =20 EXAMPLE - Double Metaphone Functions=20 =20 =20 Page:<= /span>=20 =20 Case Transform=20 =20 =20 Page:<= /span>=20 =20 CASE Function=20 =20 =20 Page:<= /span>=20 =20 Apply Conditional Transformations=20 =20 =20 Page:<= /span>=20 =20 IF Function=20 =20 =20 Page:<= /span>=20 =20 String Data Type=20 =20 =20 Page:<= /span>=20 =20 DOUBLEMETAPHONE Function=20 =20 =20 Page:<= /span>=20 =20 Modify String Values=20 =20 =20 Page:<= /span>=20 =20 String Functions=20 =20 =20 Page:<= /span>=20 =20 CHAR Function=20 =20 =20 =20 =20 =20 Syntax and Arguments =20 =20 stringgreaterthan(string_ref1,string_ref2 = <span>[,ignore_case]</span>) =20 =20 =20 =20 =20 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 t= o apply to the function ignore_case N string When true, matching is case-insensitive. Default is false= . For more information on syntax standards, see Language Documentation Syntax Notes<= /a>. string_ref1, s= tring_ref2 String literal, column reference, or expression whose elements you want = to compare based on this function. Usage Notes: =20 =20 =20 =20 =20 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&nb= sp;false.  NOTE: This argument is not required. By default, matche= s are case-sensitive. Required? Data Type Example Value No String literal evaluating to a Boolean 'true' E= xamples =20 =20 =20 Tip: For additional examples, see Common Tasks.=20 = Example - Simple string comparisons This example demonstrates functions that can be used to compare t= wo 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 formulaParameter: Formula typeSingle row formulaParameter: FormulaSTRINGGREATERTHAN(stringA,stringB)<= /td>=20 Parameter: New column name'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 formulaParameter: Formula typeSingle row formulaParameter: FormulaSTRINGGREATERTHANEQUAL(stringA,stringB) Parameter: New column name'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 formulaParameter: Formula typeSingle row formulaParameter: FormulaSTRINGLESSTHAN(stringA,stringB)=20 Parameter: New column name'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 formulaParameter: Formula typeSingle row formulaParameter: FormulaSTRINGLESSTHANEQUAL(stringA,stringB)Parameter: New column name'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 formulaParameter: Formula typeSingle row formulaParameter: FormulaEXACT(stringA,stringB)Parameter: New column name'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 See Also for EXAMPLE - String Comparison Functions:= =20 =20 =20 Page:<= /span>=20 =20 EXACT Function=20 =20 =20 Page:<= /span>=20 =20 STRINGGREATERTHAN Function=20 =20 =20 Page:<= /span>=20 =20 STRINGGREATERTHANEQUAL Function=20 =20 =20 Page:<= /span>=20 =20 STRINGLESSTHAN Function=20 =20 =20 Page:<= /span>=20 =20 STRINGLESSTHANEQUAL Function=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 See Also for STRINGGREATERTHAN Function:=20 =20 =20 Page:<= /span>=20 =20 String Data Type=20 =20 =20 Page:<= /span>=20 =20 DOUBLEMETAPHONE Function=20 =20 =20 Page:<= /span>=20 =20 Modify String Values=20 =20 =20 Page:<= /span>=20 =20 String Collation Rules=20 =20 =20 Page:<= /span>=20 =20 String Functions=20 =20 =20 Page:<= /span>=20 =20 CHAR Function=20 =20 =20 Page:<= /span>=20 =20 UNICODE Function=20 =20 =20 Page:<= /span>=20 =20 UPPER Function=20 =20 =20 Page:<= /span>=20 =20 LOWER Function=20 =20 =20 Page:<= /span>=20 =20 PROPER Function=20 =20 =20 =20 =20 =20   ```
``` ------=_Part_183_383747116.1675861577139-- ```
{"ft_lang_label":"__label__en","ft_lang_prob":0.54038215,"math_prob":0.9761002,"size":7158,"snap":"2022-40-2023-06","text_gpt3_token_len":2072,"char_repetition_ratio":0.15809338,"word_repetition_ratio":0.25803572,"special_character_ratio":0.28946632,"punctuation_ratio":0.12908366,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.99996865,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2023-02-08T13:06:17Z\",\"WARC-Record-ID\":\"<urn:uuid:8f058c31-ae7e-45ce-a0af-9c9fba94507c>\",\"Content-Length\":\"40771\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:00cd7bb5-a05e-4474-bc76-661dd70406d3>\",\"WARC-Concurrent-To\":\"<urn:uuid:728ce119-43fe-4409-8d74-bde410f4c5a2>\",\"WARC-IP-Address\":\"18.237.36.149\",\"WARC-Target-URI\":\"https://docs.trifacta.com/exportword?pageId=109906352\",\"WARC-Payload-Digest\":\"sha1:YRVJ6KVRW4ERGLUQSTPLIDHO4OI4QJX7\",\"WARC-Block-Digest\":\"sha1:SMFEL6HCEAPJXMLNU7UKU6YSZD3MEWVI\",\"WARC-Identified-Payload-Type\":\"message/rfc822\",\"warc_filename\":\"/cc_download/warc_2023/CC-MAIN-2023-06/CC-MAIN-2023-06_segments_1674764500813.58_warc_CC-MAIN-20230208123621-20230208153621-00634.warc.gz\"}"}