Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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")[, , ,]
  • No labels