concat()

Read(365) Label: parameter, concatenate, string,

Description:

Concatenate parameters into a string.

Syntax:

concat(xi,…)

Note:

The function concatenates parameters xi,… into a string in which quotation marks will not be used

Parameters:

xi

Any value that can be converted to a string; if it is a sequence, it will be broken up before concatenation.

Return value:

A string

Example:

 

A

 

1

=demo.query("select * from SCORES where SCORE>90")

2

=A1.(SCORE)

 

3

=A1.(SUBJECT)

 

4

=concat(A2,A3)

979691939797979691939797PEEnglishPEEnglishMathMathPEEnglishPEEnglishMathMath

5

=concat(2,3,"a")

23a

Related functions:

s.split()