Contains() determines if at least one of the values retrieved from a repeating section, page or data source matches a specified value. Note that the value must be an exact match, although it is not case sensitive.

Returns 1 if any values match or 0 if no values match.

Usage:

Contains( p1, p2[, p3…])

Parameters:

p1

The value to search for.

p2

Reference to a question within a repeating page, repeating section or multiple row data source.

[p3 …]

Optional additional references to extend the data set being matched.

Example:

The examples below return true or false values based on whether the value ‘inactive’ is found in the ‘Account’ field from a multi row data source question.

contains("inactive", [Q5.account])

Related Articles

Infiniti Design Functions

Function NotContains() 

Keywords

Design Formula Format Contains