Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.5
10.0
10.1
10.2
10.3
10.4
10.5
11.0
11.1
11.2
Statistic
FMM
Blog
Returns a list with values which are contained in both lists.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
List | 10.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
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 | 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 | Optional |
Returns list or error.
AND two lists based on 2 column:
MBS( "List.AndColumn";
"1 test 3¶a b c¶d¶e f";
"2 test 4¶a f c¶d b";
" "; 1 )
Example result:
2 test 4
a f c
d b
Created 23th December 2019, last changed 1st February 2021
Feedback: Report problem or ask question.