E()

Read(1451) Label: two-level sequence, conversion,

Description:

Convert a string, two-level sequence, table sequence or record sequence to a specific type.

Syntax:

E(x)

Note:

When parameter x is a two-level sequence, convert it to a multi-row table sequence where each row is a record and the first row holds column headers;

 

When parameter x is a string of rows separated by carriage return or a string of tab-separated columns, split them before conversion;

Convert to a two-level sequence when parameter x is a table sequence or a record sequence.

Parameter:

x

A sequence/string/table sequence/record sequence

Option:

@b

Do not use headers

@p

Transpose the two-level sequence

@s

Return a string separated by carriage return or tab when parameter x is a table sequence

Return value:

A table sequence, a sequence, or a string

Example:

 

A

 

1

=connect("demo").query("select EID,NAME,DEPT,SALARY,HIREDATE from EMPLOYEE ")

2

=E@s(A1)

Return a string separated by carriage return or tab:

3

=E(A2)

4

=E@b(A3)

5

=E@bp([[1,4,5,6],["Emily","Ashley","Kuki","Lily"]])