NextGen Knowledge Center

CONCAT Function

Use:Determines the concatenated value.
Syntax:
{CONCAT( «delimiter» , «grammer», «use caption» , «list» )}
Arguments:

«delimiter»
    Determines the character to separate items when concatenating. To use a comma (,) as a Delimiter and spelled out as the word "Comma".
«grammar»
    Value to separate the last item in the concatenated list.
«use caption»
    If a radio button or check box is used in the list it returns the caption instead of the value of the radio button or check box.
«list»
    List of fields and or variables to concatenate together.
Returns:Return the value.
Example1:

{CONCAT( "Comma" , "or", "FALSE", {local.picklistvalues})}
{local.picklistvalues} = "red, blue, green"

Result = red, blue, or green

Example2:

Using Caption
{CONCAT( "Comma" , "and", "TRUE", {local.chk1},{local.chk2},{local.chk3})}
{local.chk1} caption = Red
{local.chk2} caption = Blue
{local.chk3} caption = Green

Result = Red, Blue and Green

Example3:

Not using Caption
{CONCAT( "Comma" , "and", "FALSE", {local.chk1},{local.chk2},{local.chk3})}
{local.chk1} = 1
{local.chk2} = 0
{local.chk3} = 1

Result = 1, 0 and 1

Example4:

Using LIKE function to get check boxes on the template with table name of local. File name is chk, value is 1 and field is check box.
{CONCAT( "Comma" , "and", "TRUE", {LIKE({P(Table:"local", Field: "chk%", Value: "1", Control:"Checkbox")} )})}
{local.chk1} caption = Red is checked = 1
{local.chk2} caption = Green is checked = 1
{local.chk3} caption = Blue is not checked = 0

Result = Red and Green