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 r0810

D toc

Excerpt

Returns true if the rightmost set of characters of a column of values matches a pattern. The source value can be any data type, and the pattern can be a

D s lang
itempattern
rtrue
, regular expression, or a string.

  • The ENDSWITH function is ideal for matching based on patterns for any data type. If you need to match strings using a fixed number of characters, you should use the RIGHT  function instead. See RIGHT Function.
  • See STARTSWITH Function.

D s lang vs sql

D s
snippetBasic

String literal example:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:endswith(tweets,'?') as:'hasQuestion'

endswith(tweets,'?')

Output: Returns true if last letter of the tweets column value is "?". 

D s lang
itempattern
  example:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:endswith(tweets,`{hashtag}{1,9}`) as:'hasHashtag'

endswith(tweets,`{hashtag}{1,9}`)

Output: Returns true if the tweets column ends with 1-9 hashtag values. Otherwise, the returned value is false.

Regular expression example:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextset col:Status value:if(endswith,myNum,/([01][0-9][0-9]|2[0-4][0-9]|25[0-5])/),'myNum - valid','myNum - error')

if(endswith,myNum,/([01][0-9][0-9]|2[0-4][0-9]|25[0-5])/),'myNum - valid','myNum - error')

Output: Returns myNum - valid if the value of the myNum column ends with a value between 0-255. Otherwise, myNum - error is returned.

D s
snippetSyntax

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:endswith(column_any,pattern)

endswith(column_any,pattern[,ignore_case])


ArgumentRequired?Data TypeDescription
column_anyYanyName of the column to be applied to the function
patternYstringPattern or literal expressed as a string describing the pattern to which to match.
ignore_caseNstringWhen true, matching is case-insensitive. Default is false.

D s lang notes

column_any

Name of the column to be searched.

  • Multiple columns and wildcards are not supported.

D s
snippetusage

Required?Data TypeExample Value
YesColumn referencemyColumn

pattern

D s item
itempattern
, regular expression, or string literal to locate in the values in the specified column.

D s
snippetusage

Required?Data TypeExample Value
YesString`{zip}`

ignore_case

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

Info

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

D s
snippetusage
 

Required?Data TypeExample Value
NoString value'false'

D s
snippetExamples

Example - STARTSWITH and ENDSWITH Functions

Include Page
EXAMPLE - STARTSWITH and ENDSWITH Functions
EXAMPLE - STARTSWITH and ENDSWITH Functions

D s also
labelstring