Function LISTCOMPACT
remove empty items at the and and at the start of the list
Example
listcompact(string list,[string delimiters,[boolean multiCharacterDelimiter]]):string
Arguments
The arguments for this function are set. You can not use other arguments except the following ones.
| Name | Type | Required | Description |
|---|---|---|---|
| list | string | Yes | a string list |
| delimiters | string | No | Characters that separate list elements. The default value is comma. |
| multiCharacterDelimiter | boolean | No | specifying whether the delimiters parameter specifies a multi-character delimiter. If this parameter is true, the delimiters parameter must specify a single delimiter consisting of multiple characters. This parameter enables the ListToArray function to convert a list such as the following to an array of color names: red:|orange:|yellow:|green:|blue:|indigo:|violet. |