Versions Compared

Old Version 4

changes.mady.by.user Unknown User (a.jansen)

Saved on

compared with

New Version Current

changes.mady.by.user Tijmen Daatselaar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColorwhite

JOIN


Joins a series of values into one string, separated with a character of your choice.


Syntax

Code Block
JOIN ( argument1 , argument2 , ... , separator )



Inputs
  • argument1, argument2 - Attributes or expressions that contain the values that will be joint to a single string. JOIN works for all base types, even multivalued.
  • separator - A string value that will be used as separator symbol.


Return type

  • string
note
Info

An

UI Text Box
typenote
an

UNKNOWN value will be represented as an empty entry in the result string.

UI Text Box
type
Info

The CONCAT function is identical to the JOIN function, except for handling of UNKNOWN.

Examples

Suppose you have a model containing the following attributes.


AttributeBasetypeValue
Person.namestring"John"
Person.date_of_birthdate01-01-1995
Person.family_namestring
ExpressionResultType
JOIN ( Person.name , Person.date_of_birth , ";" )"John;Sun Jan 01 00:00:00 CET 1995"String
JOIN ( Person.name , Person.name , "@" )"John@John"String
JOIN ( Person.name , Person.family_name , YEARS BETWEEN Person.date_of_birth AND DATE ( 2015 , 01 , 01 ) , ";" )"John;;20"String


Back to top