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