• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# to()

Here’s how to use to() function.

## A. to()

Description:

Get members of a sequence starting from a specified position to create a new sequence.

Syntax:

 A.to(a) From sequence A, generate a sequence composed of the first a members; when a<0, get members from the (A.len()+1+a)th one to the (A.len())th one A.to(a,b) From the sequence A, generate a sequence composed of the members from the ath to the bth. If omitting a, then start from the first member by default; if omitting b, get all members of A, that is A.len(), by default, and in this case the comma must not be omitted; if a>b, find the members backwards; members of the newly-generated sequence are ordered in an opposite direction relative to their original order

Note:

The function generates a sequence composed of the members from the ath to the bth according to sequence A. If omitting a, start from the first member by default; If omitting b, get members to the last one, that is A.len() by default.

Parameter:

 A A sequence a The integer specifying the starting position b The integer specifying the ending position

Return value:

Sequence

Example:

 [1,5,2,6,8].to(2,3) Return sequence [5,2]. [1,5,2,6,8].to(3,2) Return sequence [2,5]. [1,5,2,6,8].to(2) Return sequence [1,5]. [1,5,2,6,8].to(-2) Return sequence [6,8].

Related function:

## to()

Description:

Generate an integer sequence.

Syntax:

 to(a,b) Generate a sequence composed of continuous integers between a and b to(n) Generate a sequence composed of continuous integers from 1 to n

Note:

The function generates a sequence composed of a set of continuous integers from a to b or from 1 to n.

Parameter:

 a The starting integer b The ending integer n n>0

Option:

 @s Generate a sequence composed of continuous b integers starting from a. If b is less than 0, generate the sequence backward sequentially in descending order

Return value:

A continuous integer sequence

Example:

 A 1 =to(3,7) [3,4,5,6,7] 2 =to(5,3) [5,4,3] 3 =to(-2,3) [-2,-1,0,1,2,3] 4 =to(3,-2) [3,2,1,0,-1,-2] 5 =to@s(3,4) [3,4,5,6] 6 =to@s(3,-2) [3,2] 7 =to(10) [1,2,3,4,5,6,7,8,9,10]

Related function: