Returns a sorted pipebar (|) delimited string of values in List A which match those in List B.
SppCompareListsForMatches([List A],[List B])
Where:
List A is a pipebar (|) delimited list of items as a string.
List B is a pipebar (|) delimited list of items as a string.
| Rule | Result | Meaning |
|---|---|---|
| SppCompareListsForMatches("1|2|1|4|5","1|3|5|6") | 1|1|5 | Will return a pipebar (|) delimited list of all the matches from the two lists. |