SortValue

<< Click to Display Table of Contents >>

Manual > Control Reference > Route > Route Methods >

SortValue

 

Sorts values in ascending or descending order.

 

syntax

SortValue(

         val,

         [,type = ""]

         [,reverse = FALSE]

         )

 

Parameters

 

val

 

Type:

General purpose

 

Specifies the table data to be sorted. Multiple values can be specified as an array.

 

type

 

Type:

character

 

Type specification.

"" - Automatic

"text" - Sort based on values converted to text

"number" - Sort based on the converted number

"time" - Sort by the converted time value

 

reverse

 

Type:

Boolean

 

TRUE - descending

FALSE - ascending

 

Return Value

 

 

Type:

character

 

The index information that was sorted.

 

hmtoggle_plus1Example

To rearrange sequence data

 

 

var val, vSortIndex, vNewData;
val = c(c("2", "8", "4"), c("1","2","1"))

//To sort the first dimension of "val" in ascending numerical order, specify as follows. 
vSortIndex = ::SortValue(val[0, ], "number", F);

//The indexes resulting from sorting using the above sorting criteria are returned in a one-dimensional array in "vSortIndex". 
//As shown below, you can obtain the sorted result of the array by specifying the returned value "vSortIndex" as the original data array "val". 
vNewData = val[ , vSortIndex];

 

vNewData will store the sorted "c(c("2", "4", "8"), c("1","1","2"))".

If you have multiple sort keys, use the SortTable method.

 

 

Supported

○

Script Action

Can be used in server script Ver2 actions

○

Browser script

Can be used in browser scripts

×

Calculation Expression Syntax

Can be used in expression syntax (e.g. bind syntax)

 

 

reference

 

SelectVal (SV)

GetRemainder

Nums

RepeatValue

SortValue

GetUniqueValue

IsExist