| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.XOrColumn
Returns list with values found in either first or second list, but not in both.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 10.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.XOrColumn"; 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 list with values found in either first or second list, but not in both.Performs an exclusive logical OR operation.
Checks the given column in both lists too compare.
If Separator is empty, this is same as List.XOr, but slower.
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
