Concat

aggregating category: string no `||`

Concatenates any number of strings, mixing field references and static literals.

Concatenates string parameters in the order they are given. Inputs are passed by :-notation reference; static strings can be interleaved.

Parameters

N — parts Mandatory — accepts: field, STRING

The Nth component of the resulting string. May be a field reference (:f) or a static string. Any number of parts can be given.

Input type

• STRING

Output type

• STRING

Requires

• Concat works both with and without inputs. Without inputs it can only contain static strings.

Examples

Mix fields and a separator

Concat(:field1, " – ", :field2)

Static-only — equivalent to SetValue

Concat("I work like SetValue")

Prefix label and a field

Concat("Field7 contains: ", :field7)

Three field references

Concat(:field1, :field2, :field3)

See also

SetValue, InsertStringAt, PrePad, PostPad