# tokenize_part¶

## Description¶

Tokenizes the input string using the delimiter and returns the requested part. The delimiter is treated as a set of characters. Each character in the delimiter string is a delimiter. The default delimiter is ” “. If the delimiter is empty, and the string is empty, then the function returns NULL. If the delimiter is empty, and the string is non empty, then the whole string will be treated as one token. The part argument is 1-based and the default value is 1. If the part number is out of range, then NULL is returned

string

## Domain¶

This is a scalar function (calculates a single output value for a single input row.)

## Usage¶

tokenize_part( value [ , delimiter ] [ , part ] )


Argument

Type

Required

Multiple

value

string

Required

Only one

delimiter

string

Optional

Only one

part

int64

Optional

Only one

## Examples¶

tokenize_part("a b c d")


Returns the default part, tokenized by the default delimiter, which ends up with “a”.

tokenize_part("[email protected]", "@.")


Returns the default part of the input string tokenized by delimiter ‘@’ or ‘.’, which ends up being “hello”.

tokenize_part("[email protected]", "@.", 2)


Returns the second piece (one-based indexing) when tokenizing by delimiters ‘@’ and ‘.’, which ends up being “example”.