Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

String literal reference example:

STRINGGREATERTHAN
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
stringgreaterthan('a','b') as:'stringCompare'

stringgreaterthan('a','b')

Output:

...

 Returns false since a evaluates to be less than b.

String literal reference example:

STRINGGREATERTHAN
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
stringgreaterthan('a','ab') as:'stringCompare'

stringgreaterthan('a','ab')

Output:

...

 Returns false  since the second string contains an additional letter.

String literal reference example:

STRINGGREATERTHAN
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
stringgreaterthan('abc','x') as:'stringCompare'

stringgreaterthan('abc','x')

Output:

...

 Returns false

...

 since the first letter of the first string is less than the first letter of the second string.

Column reference example:

STRINGGREATERTHAN
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
stringgreaterthan(string1,string2) as:'stringCompare'

stringgreaterthan(string1,string2)

Output:

...

 Returns the evaluation of string1 column values being greater than string2 column values.

D s
snippetCollation Rules
styleh2

Include Page
String Collation Rules
String Collation Rules

D s
snippetSyntax

STRINGGREATERTHAN
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:
stringgreaterthan(string_ref1,string_ref2)

stringgreaterthan(string_ref1,string_ref2)


ArgumentRequired?Data TypeDescription
string_ref1YstringName of first column or first string literal to apply to the function
string_ref2YstringName of second column or second string literal to apply to the function

...