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 r0821

D toc

Excerpt

Returns true if the second string evaluates to be an exact match of the first string. Source values can be string literals, column references, or expressions that evaluate to strings.

D s lang vs sql

D s
snippetBasic

String literal reference example:

D lang 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:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:exact('a','A') as:'stringExactCompare'

exact('a','A')

Output: Returns false, since the capitalization is different between the two strings.

Column reference example:

D lang 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

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:exact(string_ref1,string_ref2)

exact(string_ref1,string_ref2 [,ignore_case])


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
ignore_caseNstringWhen true, matching is case-insensitive. Default is false.

D s lang notes

string_ref1, string_ref2

String literal, column reference, or expression whose elements you want to compare based on this function.

D s
snippetusage

Required?Data TypeExample Value
YesString literal, column reference, or expression evaluating to a stringmyString1, myString2

ignore_case

When true, matches are case-insensitive. Default is false

Info

NOTE: This argument is not required. By default, matches are case-sensitive.

Required?Data TypeExample Value
NoString literal evaluating to a Boolean'true'


D s
snippetExamples

Example - Simple string comparisons

Include Page
EXAMPLE - String Comparison Functions
EXAMPLE - String Comparison Functions

D s also
labelstring