InList

Returns a Boolean to indicate if the specified string exists within the Databox value.

Returns True if text is in list. Arguments are the list of items separated by the delimiter specified in the 2nd argument (usually, but not restricted to commas).

Expression
Databox Value
Result
Comments

Inlist("A,B,C", ",")

[Any of] A, B or C

True

True as text is in list.

Inlist('107753;75536;86653', ';')

86653

True

Note semi-colon separator and use of single quotes to envelope arguments

Last updated