Home Search

DriveWorks Pro 21
ListGetCommon

Send Feedback

ListGetCommon

Compares two pipebar delimited lists (|) and returns the common items with options for case sensitive checking and including duplicate values.

Syntax

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.

Examples

RuleMeaning
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".