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).
Note that an exact match is required e.g. text case and spaces
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
Was this helpful?