TOKENIZELIST
- Juliane Wetzel
Owned by Juliane Wetzel
Feb 07, 2020
Loading data...
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 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") | [, , ,] |