| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.OrColumn
Returns values of both lists.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 10.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.OrColumn"; List1; List2; Separator; Column { ; NoReturnEnding } ) More
Parameters
| 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 |
Result
Returns list or error.
Description
Returns values of both lists.Performs a logical OR operation.
Checks the given column in both lists too compare.
If Separator is empty, this is same as List.Or, but slower.
Examples
Trying OR based on second column:
MBS( "List.OrColumn"; "1 test 3¶a b c¶d¶e f"; "2 test 4¶a f c¶d b"; " "; 1 )
Example result:
1 test 3
a b c
d
e f
2 test 4
See also
Release notes
- Version 10.0
- Added List.AndColumn, List.NotColumn, List.OrColumn, and List.XOrColumn functions.
- Added QuickList.AndColumn, QuickList.NotColumn, QuickList.OrColumn, and QuickList.XOrColumn functions.
Blog Entries
This function checks for a license.
Created 23th December 2019, last changed 23th December 2019
