concat

concat, process

def process concat(a: text): text

The process returns the resulting concatenation of the text values. It requires an ordering option, either sort or scan.

Examples

table T = with
  [| as A, as B |]
  [| "hello ", "a" |]
  [| "hello ", "a" |]
  [| "hello ", "b" |]
  [| "world",  "b" |]
  [| "world",  "c" |]

table G[gdim] = by T.B

where T.B != "c"
  show table "" a1b4 with
    gdim
    concat(T.A) sort T.A
    group by gdim

Remarks

The ordering option can be applied to any ordered data type.

Beware, text values are limited to 256 characters in Envision.

It would also be possible to re-implement concat with a user-defined process:

def process myConcat(a : text) with
  keep c = ""
  if c == ""
    c = a
  else
    c = "\{c}\{a}"
  return c

See also

concat, pure function (variadic)

def const pure concat(...t: _typ): text

Returns the concatenation of all the values - of any data types - passed as argument. The function is variadic.

Examples

show summary "" a1d3 with
  concat("0", 1, "2", 3) // returns "0123"
  concat("Hello", " ") // returns "Hello "
  concat("Hello", " ", "World") // returns "Hello World"
  concat("Hello", " ", "World", "!") // returns "Hello World!"

All the input values, if not text values already, are converted to text using the text function.

This function is similar to the CONCAT Excel function.

See also

User Contributed Notes
0 notes + add a note