@IsMember (Formula Language)

Syntax

@IsMember( textValue ; textListValue ) @IsMember( textListValue1 ; textListValue2 )

Parameters

textValue

Text.

textListValue

Text list.

textListValue1

Text list.

textListValue2

Text list.

Return value

flag

Boolean

• Returns 1 (True) if the textValue is contained in textListValue
• Returns 0 (False) if not
• If both parameters are lists, returns 1 if all elements of textListValue1 are contained in textListValue2

Usage

In processing lists, @IsMember differs from a simple = test. An = returns True if the pair-wise comparison of two entities has even one member; that is, it is not empty.

@IsMember returns True only if the first parameter is an exact match, or a subset of the second parameter which is a list.

Examples

1. This example returns 1.

   @IsMember("computer";"printer":"computer":"monitor")

2. This example returns 0.

   @IsMember("computer":"Notes";"Notes":"printer":"monitor")

3. This example returns 1 if R&D is in the list in the Department field, returns 0 if R&D is not in the list.

   @IsMember("R&D";Department)

4. This example returns 1, since Fred is a subset of a list.

   @IsMember("Fred"; "Barney":"Wilma":"Fred")