Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 8.3   8.4   8.5   9.0   9.1   9.2   9.3   9.4   9.5   10.0    Statistic  

List.NotColumn

Returns values of first list which are not in second list.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
List 10.0 Yes Yes Yes Yes Yes
MBS( "List.NotColumn"; List1; List2; Separator; Column { ; NoReturnEnding } )   More

Parameters

Parameter Description Example value
List1 The first list. "Hello" ¶ "World"
List2 The second list. "Hello" ¶ "Friends"
Separator The separator text.
Can be multiple characters.
For tab separated text, pass Char(9). For CSV separated text, pass ";" or ",".
Char(9)
Column The index of the column to compare.
Starts with 0 for first column.
0
NoReturnEnding Optional
Pass 1 to have no extra newline character on the end of the returned list. Default is 0 to include one to easily concat lists.
1

Result

Returns list or error.

Description

Returns values of first list which are not in second list.
Performs a logical NOT operation.

Checks the given column in both lists too compare.
If Separator is empty, this is same as List.Not, but slower.

See also

Blog Entries

Created 23th December 2019, last changed 23th December 2019


List.Not   -   List.Or

Feedback: Report problem or ask question.




Links
MBS Xojo PDF Plugins