---
title: "Concat"
slug: "concat"
updated: 2024-04-16T11:16:20Z
published: 2024-04-16T11:16:20Z
canonical: "help.mail-and-deploy.com/concat"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.mail-and-deploy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Concat

### General

The Concat function can be used to concatenate a series of values using a separator.

          
          

> **Example:** You can use the Concat function to concatenate all values of a Datasource field with a separator such as a colon.

Syntax The syntax of the Concat function is:

          Concat Function Syntax

          

Concat(<separator>, <value_list>)

### Examples

The following Expression returns a String that contains all values of the field SalesRepName of a Datasource named Consumer Sales separated by a comma and a whitespace:

          Concat Function Example

          

Concat(", ", [Datasource].[Consumer Sales].[Field].[SalesRepName])

The following example does the same but puts every value into a line of its own:

          Concat Function Example

          

Concat(NewLine(), [Datasource].[Consumer Sales].[Field].[SalesRepName])