TOKENIZELIST

Syntax

TOKENIZELIST(<string>;<Separator string>;<number>)

Description

Tokenizes text returning a list of values or a specified element as a string. A blank string returns a blank list item.

Examples

Column1Example TOKENIZELIST functionTOKENIZELIST returns
a b c d e fTOKENIZELIST(#RawData!Column1;" ")[a, b, c, d, e, f]
Datameer X is great!TOKENIZELIST(#RawData!Column1;" ")[Datameer X is, great!]
Datameer-is-great!TOKENIZELIST(#RawData!Column1;"-")

[Datameer X is, great!]

a b c d e fTOKENIZELIST(#RawData!Column1;" ";3)d


If the separator value is followed by the same separator value, an empty value is returned in the list.

Column1Example TOKENIZELIST functionTOKENIZELIST returns
a-b-c-d-e- -fTOKENIZELIST(#RawData!Column1;"-")[a, b, c, d, e, , f]
aaaTOKENIZELIST(#RawData!Column1;"a")[, , ,]