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:

EXACT
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
exact('a','a') as:'stringExactCompare'

exact('a','a')

Output:

...

Returns true

...

, since the values are identical.

String literal reference example:

EXACT
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
exact('a','A') as:'stringExactCompare'

exact('a','A')

Output: Generates Returns false in the new column stringExactCompare, since the capitalization is different between the two strings.

Column reference example:

EXACT
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive 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 s
snippetSyntax

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

exact(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

...