TOKENIZELIST

Syntax

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

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

Column1	Example TOKENIZELIST function	TOKENIZELIST returns
a b c d e f	TOKENIZELIST(#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 f	TOKENIZELIST(#RawData!Column1;" ";3)	d

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

Column1	Example TOKENIZELIST function	TOKENIZELIST returns
a-b-c-d-e- -f	TOKENIZELIST(#RawData!Column1;"-")	[a, b, c, d, e, , f]
aaa	TOKENIZELIST(#RawData!Column1;"a")	[, , ,]