~( i )

Read(172) Label: a sequence of sequences,

Description:

Get one or more child members of each member sequence in a sequence.

Syntax:

~(i)

Note:

The function gets the ith child member of each member sequence in a sequence. The parentheses can be omitted and the function can be simply written as ~i.

Parameter:

i

An integer

Return value:

Sequence

Example:

 

A

 

1

=file("emp.txt").cursor@w().fetch()

Return a sequence of sequences:

2

=A1.(~2)

Get the 2nd child member of each member sequence in A1’s sequence:

3

=A1.([~(1),~2])

Get the 1st and the 2nd child member of each member sequence in A1’s sequence:

4

=A1.groupc(~(3);[(~1),(~2)])

Group A1 by the 3rd child member of each member sequence, performs transposition on it and return the following result: