This shows you the differences between two versions of the page.

Link to this comparison view

expression function - concatenate [2016/09/14 14:19]
expression function - concatenate [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Concatenate (Expression Function) ======
 +===== Purpose =====
 +The **Concatenate** function (CONCAT) takes inputs of any number of values, and returns the text of all of the values concatenated together.
 +===== Parameters =====
 +The **Concatenate** function has an unlimited number of parameters:
 +==== Values ====
 +Allowed Inputs: [[Field|field]] value or text string
 +The builder can enter as many inputs into the concatenate function as they want. Either use the use the [[Query Builder]] to choose a field that contains a value or use type a value to enter a text string. When using the wizard to build the function after each new value is entered a new blank option will allow the builder to keep adding more values. ​ When using a query to find a field value if more than one value is found then only the first value is used.  So if you have a query that searches for Contact records and it would find the values "​Bob"​ and "​Alice"​ and it is used in CONCAT(${Contact - First Name}, ", ") the result will be "Bob, "​. ​ If you want to generate a string that contains all the values then you should use [[Expression Function - Build a List|BUILD_A_LIST]](${Contact - First Name}, ", ") which would generate "Bob, Alice"​.
 +===== Output =====
 +The output of the **Concatenate** function is a string comprised of the values defined concatenated together into one string. For example CONCAT("​The quick","​brown","​ ","​fox"​) would result in "The quickbrown fox". The concatenate function will return even if one or more of the values is blank. So if a Contact record has a last name filled in but no first name and CONCAT(${Contact - Last Name},",​ ",​${Contact - First Name}) the output will be "Last Name, ".
 +===== Example =====
 +Most often used to concatenate different field values together such as the First Name and Last Name of a Contact. ​ CONCAT(${Contact - Last Name},",​ ",​${Contact - First Name}) would result in something like "Doe, John"
expression function - concatenate.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2021