Navigation:  MCL Reference > List Functions >

ListAscVal( )

Print this Topic Previous pageReturn to chapter overviewNext page

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