CONCAT
Usage
Use this function to concatenate two or more strings
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER STORAGE | STRING | .VALUE |
Syntax
1 | |
Arguments
String_1
any column field string value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), string constant between quotation marks ("constant"), System Variables or function-returned string value
String_n
any column field string value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), string constant between quotation marks ("constant"), System Variables or function-returned string value
Note
This function is mainly used in calculated fields or as argument of conditional expressions
Return Value
String
Examples
Example 1
Formula
=CONCAT($CURRENTUSER.NAME; " "; $CURRENTUSER.SURNAME)
Description
Concatenate current User name (example: John) + empty space (" ") + current User surname (example: Smith)
Result
John Smith
Example 2
Formula
=CONCAT(#HR.Surname.VALUE; "-"; #HR.Email.VALUE; "-"; #HR.Role)
Description
We perform this formula in a calculated field where we want to create a key concatenating the value of the column Surname of Storage HR + line ("-") + the value of the column Email of Storage HR + line ("-") + the value of the column Role of Storage HR
Result
Smith-john.smith@email.com-Manager
Example 3
Formula
=CONCAT(#Invoice.Number.VALUE; "/"; #Invoice.Quantity.VALUE; "/";
=LOOKUP(
#Customers;
#Customers.Name;
#Customers.Id_Customer == #Invoice.Id_Customer.VALUE
)
)
Description
We perform this formula in a calculated field where we want to create a key concatenating the value of the column Number of Storage Invoice + slash ("/") + the value of the column Quantity of Storage Invoice + slash ("/") + from Storage Customers the value of the column Name where the column Id_Customer of the Storage Customers matches with the value of the column Id_Customer of the Storage Invoice
Result
123/10/Customer_XYZ