Home Search

DriveWorks Pro 21
ListRemoveEmpty

Send Feedback

ListRemoveEmpty

Removes empty values in the given list.

Syntax

ListRemoveEmpty([List],[RemoveWhiteSpace])

Where:

List is the list from which to remove empty values.

RemoveWhiteSpace (Optional) removes entries consisting only of whitespace.

Examples

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

Example Data

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)

Customers Table

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