Skip to main content

Contains

This formula returns true if the specified needle value is contained in the haystack.

JSON Format

{
"type": "contains",
"haystack": ...,
"needle": ...
}

Fields

FieldTypeRequiredDescription
haystackStatFormulaComponentA formula returning an array (list) or string that the needle will be looked in for.
needleStatFormulaComponentA formula returning a value to look for in the haystack. It has to be a string if the haystack returns a string. Otherwise it should be of the sub_value_type of the array returned by haystack.