Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc
Excerpt

Returns true if the leftmost 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 item
itempattern
, regular expression, or a string.

  • The STARTSWITH 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 LEFT  function instead. See LEFT Function.
  • See ENDSWITH Function.

D s
snippetBasic

String literal example:

D code

derive value:STARTSWITH(FullName,'Mr.')

Output: Writes true into a new column if the first three letters of the FullName column value are "Mr.". 

Trifacta pattern example:

D code

derive value:STARTSWITH(CustId,`{alpha-numeric}{6}`) as:'validateCustId'

Output: Generates the validateCustId column containing true if the CustId column begins with a six-digit alpha-numeric sequence. Otherwise, the validateCustId column is set to false.

Regular expression pattern example:

D code

set col:Status value:IF(STARTSWITH,phone,/^(\+0?1\s)?\(?\d{3}\)?[\s.-]\d{3}[\s.-]\d{4}$/),'phone - ok','phone - error')

Output: Sets the value in the Status column to phone - ok if the value of the phone column begins with a value that matches a 10-digit U.S. phone number. Otherwise, the Status column is set to phone - error.

D s
snippetSyntax

D code

derive value:STARTSWITH(column_any,pattern)

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.

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}`

D s
snippetExamples

Example - STARTSWITH and ENDSWITH Functions

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

D s also
labelstring