List(Text delimiter, Text value1, Text value2, …, Text valueN)

Concatenates all value arguments starting with the second argument, using the first argument as a delimiter between them.

Parameters

delimiter

The text value to use as a delimiter between concatenated values.

value

The text value to concatenate.

Returns

Text

Remarks

If one of the arguments is blank, this argument and the corresponding delimiter are omitted.

Examples

• List("-", "model", "a", "2012") returns "model-a-2012".
• List(" ", [First Name], [Last Name]) takes the value "John" stored in the First Name Column and the value "Smith" stored in the Last Name Column, returns the text value "John Smith". If the Last Name column value is blank, it returns the value "John". If the First Name column value is blank, it returns "Smith".