Removes duplicates from a list using case sensitive comparison, keeping the first entry of the duplicated item.
ListRemoveDuplicates([List],[Ignore Case])
Where:
List is the list to remove duplicates from in the form of a pipebar (|) delimited string.
Ignore Case (Optional) is TRUE to perform a case insensitive check for a duplicate entry. False (or ignored) will not remove duplicates if the case does not match.
Rule | Meaning |
|---|---|
| ListRemoveDuplicates(DWVariableCustomerList) | Will remove only exact matches. The list (See Example Data below) will become: All Stars|all stars|Boston bulls|Boston Bulls|cambridge cats|Cambridge cats| |
| ListRemoveDuplicates(DWVariableCustomerList, FALSE) | Will remove only exact matches. The list (See Example Data below) will become: All Stars|all stars|Boston bulls|Boston Bulls|cambridge cats|Cambridge cats| |
| ListRemoveDuplicates(DWVariableCustomerList, TRUE) | Will remove all matches regardless of case. The list (See Example Data below) will become: All Stars|Boston bulls|cambridge cats| |
DWVariableCustomerList value is "All Stars|all stars|all stars|Boston bulls|Boston Bulls|Boston bulls|cambridge cats|cambridge cats|Cambridge cats"
(created using a ListAll() Function on the Customers table below)
| Customer Name |
|---|
| All Stars |
| all stars |
| all stars |
| Boston bulls |
| Boston Bulls |
| Boston bulls |
| cambridge cats |
| cambridge cats |
| Cambridge cats |