Applies to Infiniti v8.0 or later
 
Returns a string created by concatenating of any number of strings or question references.

Usage:

Concat( p[1], p[2], .., p[n] )

Parameters

p[n] An expression or value to be concatenated, which may include equations, question references and function calls.

Example:

Build a sentence:
This example shows the Concat() function being used to build a typical sentence.
 
Concat([q1.firstName], " has ", [q7.NumberChildren], "children")
 
or to handle the plural
 
Concat([q1.firstName], " has ", [q7.NumberChildren], iif(isequal([q7.NumberChildren],"1")," child"," children"),".")
 
Assuming ‘John’ has two children the concat() function would return: John has 2 children.

 

Related Articles

 

Keywords

format sentence joinif join first firstname numberchildren number children