@IsMember (Formula Language)

Indicates if a piece of text (or a text list) is contained within another text list. The function is case-sensitive.

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")