Record constant

Read(88) Label: constant, json,

Description:

A JSON-style record style.

Syntax:

{Fi:…,…}

Note:

The record constant is in JSON style. It can be used in both a constant cell or a parameter. The expression will be computed when it is located in a larger computing expression, and it will be identified as a string when used as a constant. In the latter case, only the basic simple data types will be identified.

Parameters:

Fi

Column name in a record

Return value:

A record

Example:

  Define a cellset parameter:

 

 

A

 

1

=arg1

Return result as follows:

2

{name:Jone,score:435}

Return result as follows:

XOR-enabled sequence

Description:

Generate a new sequence by arranging distinct members (or single values) in two sequences.

Syntax:

A%B

Note:

The operator enables a new sequence by arranging distinct members (or single values) in sequenceA and sequence B. Won’t repeate distinct operation over same members.

Parameters:

A

An integer sequence

B

A sequence or a single value; treated as sequence [B] when it is a value

Return value:

A sequence

Example:

 

A

 

1

=[1,2,3,4]%[2,3]

[1,4]

2

=[1,2,3,3]%[1,3]

[2,3]; won’t repeat distinct operation over same members

3

=[1,2,3]%3

[1,2]

4

=[1,2,3,3,4]%[1,1,3]

[2,3,4,1]

Related functions:

Difference between Sequences

Intersection of sequences

Union of Sequences

Alignment arithmetic operations

cmp()