pseg()

Here’s how to use pseg() function.

A.pseg( x,y )

Description

Return the ordinal number of the interval in which the parameter falls.

Syntax

A.pseg(x,y)

Note

The function returns the ordinal number of the interval in which member y falls in sequence A, which must be an ordered one. By default the sequence members form intervals that are left-closed and right-open. Parameter x is an expression which will be calculated over each member of sequence A.

 

In the cases where y is not a member of A, if y is less than the smallest member of an increasing sequence A, then return 0; if y is greater than or equal to the largest member of an increasing sequence A, then return the length of A.

Parameter

A

A sequence

x

An expression, which is a field name or a legal expression made up of field name and in which the sign ~ can be used to reference the current record; can be absent

y

Amember

Option:

  @r  Form intervals that are left-open and right-closed

Return value

The ordinal number of the interval to which y belongs

Example

 

A

 

1

[2,22,122,222,2222]

 

2

=A1.pseg(12)

1. The intervals formed by members of the sequence are [2,22), [22,122), [122,222), [222,2222) and [2222,∞).

3

=A1.pseg(2222)

5

4

=A1.pseg@r(2222)

4

5

[1,4,8]

 

6

=A5.(~+~).pseg(10)

2

7

=A5.pseg(~+~,10)

2; the expression is equivalent to A6’ s expression.

8

=A1.pseg(1)

0