TOLIST

Syntax
TOLIST(value, 'optionaldelimiter', 'optionalFilterFormula')')

Example

 TOLIST({{myfield}})
 
 TOLIST({{myfield}}, 'STARTSWITH({{this}}, "B")')
 
 TOLIST('3,6,9,62', ',', '{{this}} > 5')

Notes

The value must be text containing delimited List elements - e.g. 34|76|9

Second optional parameter is the delimiter character separating elements. Default is pipe character.

Third optional parameter applies a filter formula to the List elements gathered, leaving only elements that pass the condition. Use {{this}} to refer to the element value in formula.

Related

LIST
TOLIST (Multi-field)