Removes empty values in the given list.
ListRemoveEmpty([List],[RemoveWhiteSpace])
Where:
List is the list from which to remove empty values.
RemoveWhiteSpace (Optional) removes entries consisting only of whitespace.
Rule | Meaning |
|---|---|
| ListRemoveEmpty(DWVariableCustomerList) | Will remove empty values only. The list (See Example Data below) will become: All Stars| |all stars|Boston bulls|Boston Bulls| |cambridge cats|Cambridge cats |
| ListRemoveEmpty(DWVariableCustomerList, FALSE) | Will remove empty values only. The list (See Example Data below) will become: All Stars| |all stars|Boston bulls|Boston Bulls| |cambridge cats|Cambridge cats |
| ListRemoveEmpty(DWVariableCustomerList, TRUE) | Will remove whitespace and empty values. The list (See Example Data below) will become: All Stars|all stars|Boston bulls|Boston Bulls|cambridge cats|Cambridge cats |
DWVariableCustomerList value is "All Stars| |all stars|Boston bulls|Boston Bulls| |cambridge cats||Cambridge cats"
(created using a ListAll() Function on the Customers table below)
| Customer Name |
|---|
| All Stars |
| {represents a cell in a table that consists of whitespace} |
| all stars |
| Boston bulls |
| Boston Bulls |
| {represents a cell in a table that consists of whitespace} |
| cambridge cats |
| {represents a cell in a table that is an empty value (no whitespace)} |
| Cambridge cats |