Compares two pipebar delimited lists (|) and returns the common items with options for case sensitive checking and including duplicate values.
ListGetCommon([List 1],[List 2],[Show duplicates],[Ignore Case])
Where:
List 1 is the first list to compare.
List 2 is the second list to compare.
Show Duplicates is whether to show duplicate items in the result.
Ignore Case is whether to carry out a case sensitive comparison on the items in the lists.
| Rule | Meaning |
|---|---|
| ListGetCommon("A|B|C|A","a|b|c|d|e",FALSE,FALSE) | This will return nothing in this case. |
| ListGetCommon("A|B|C|A","a|b|c|d|e",FALSE,TRUE) | This will return "A|B|C". |
| ListGetCommon("A|B|C|A","a|b|c|d|e",TRUE,FALSE) | This will return nothing in this case. |
| ListGetCommon("A|B|C|A","a|b|c|a",TRUE,TRUE) | This will return "A|B|C|A". |