Ascending Function
Description:
The complete list, including any duplicates, sorted in ascending order.
note
This function uses ASCII-code order where uppercase letters and lowercase letters are sorted separately. To ensure uniform sorting of your data, consider applying format or case function.
Returns:
Any*
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Any* | The list. |
Examples:
When using functions inside a field, remember the field brackets:
{Ascending(VariableName)}
Expression | Result |
|---|---|
Ascending( List("b","a","c","a","b","b","d") ) | List("a","a","b","b","b","c","d") |
Ascending( List() ) | List() |