Category: Text function
This function returns the number of distinct values in the list.
Argument | Type | Description |
---|---|---|
list | List (Text) | A delimited set of string values. |
separator | Text | The delimiter to use in the concatenation of the output string. If not defined, the default is comma. |
Return value type: Number
All leading and trailing spaces are removed from around the list values.
setlength("A, B") //returns 2
setlength("A;B") //returns 1 (the default separator is comma)