Here are how to use o() functions.
Description:
Convert a sequence to an ordinary one.
Syntax:
A.o()
Note:
The function converts sequence A, which can be an ordinary sequence or a pure sequence to an ordinary sequence. When the computation involves an ordinary sequence or when it is expected that the result of the computation is not a pure sequence, sequence A will be automatically converted to an ordinary sequence.
Parameter:
A |
A sequence. |
Return value:
Sequence
Example:
|
A |
|
1 |
=["a","c","d","e","f"].i() |
Return a pure sequence. |
2 |
=A1.o() |
Convert A1’s pure sequence to an ordinary sequence. |
3 |
=[1,2].i() |
Return a pure sequence. |
4 |
=[3].o() |
Return a pure sequence. |
5 |
=A3&A4 |
Return an ordinary sequence [1,2,"3"]. |
Descripiton:
Convert a pure table sequence to an ordinary sequence.
Syntax:
P.o()
Note:
The function converts pure table sequence P to an ordinary sequence.
Parameter:
P |
A pure table sequence. |
Return value:
Table sequence
Example:
|
A |
|
1 |
=demo.query("select EID,NAME,GENDER,DEPT,BIRTHDAY from employee") |
Return a table sequence where all fields are pure ones.
|
2 |
=A1.i() |
Convert A1’s table sequence to a pure one. |
3 |
=A2.o() |
Convert A2’s pure table sequence to an ordinary table sequence. |