FORMULA LANGUAGE


@IsNotMember
Example

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

Syntax

@IsNotMember( textValue ; textListValue ) or
@IsNotMember( textListValue1 ; textListValue2 )

Parameters

textValue


textListValue
textListValue1
textListValue2
Return value

flag

Usage

In processing lists, @IsNotMember differs from a simple != test. != returns True if the pair-wise comparison of two entities has no entities in common and False only if the pair-wise comparison of the two entities finds all pairs to be equal. @IsNotMember does not perform a pair-wise comparison, but tests each element in textListValue1against all the elements in the textListValue2 and returns False if it is equal to one of them.

For further details on pair-wise operators, see Operations on lists.

@IsNotMember returns True only if no member of the first argument is contained in the second argument.

Example
See Also