This function is almost identical to ListAscItem( ) except that, in this function, items (or sub-item), which is to be sorted, will be converted to numbers before sorting. Please see ListAscItem( ) for other function details.
Syntax
ListAscVal(cValueExpr,nItemNumber,cSeparator,nSortSubItem,cSubItemSeparator,cReturnType)
Or
ListAscVal(cValueExpr,nItemNumber,cSeparator,cSortExpr,cSubItemSeparator,cReturnType)
Returns
Character
Example
ListAscVal("8,4,12",1)
Returns '4'。Compare ListAscItem("8,4,12",1), which will return '12'. It is because in text comparison, '12' is smaller than '4' (since '1' < '4').
See also
ListDescVal( ) | ListAscItem( ) | ListDescItem( ) | ListItem( ) | ListVal( ) | ListSum( ) | ListAverage( ) | ListFilter( ) |
Page url: http://www.racematenet.com/english/help/index.html?listascval.htm