CONCATENATE

The CONCATENATE function concatenates several strings into a single string.

If defined, the Separator property will be inserted between the concatenated strings.

Input/Output

Number of Connections: Min: 1/Max:Unlimited

Input	Data Type	Description
InputN	String	The string(s) to concatenate.

Output	Data Type	Description
Output1	String	The concatenated string.

Property

Name	Property Type	Description
Separator	string	A separator that is inserted between the concatenated strings.
NoSeparatorWhenEmpty	choice	Specifies to enable output option of separator when input is empty string or null. true - Don't output a separator. false - Output a separator.

Example

		Property		Output
Input1	5/	Separator	(none)	5/1/2003
Input 2	1/
Input 3	2003

		Property		Output
Input1	usr	Separator	/	usr/local/bin
Input 2	local
Input 3	bin