Concat

Description

Joins multiple argument values of any data type together as a string value and returns the value in a new column. Specified characters can be added between the joined column values.

As there is no "ToString" function available, the Concat function can be used to accomplish this action by using it with a single input value.

Use

  • Argument:
    • Select an argument. (Any)
    • Optional: Select additional arguments. (Any)
  • Output field:
    • Enter an output field name.
  • Joiner:
    • Optional: Enter joining characters added between concatenated values.

Examples

Joining a First and Last Name

In this example ,there is a first name input field and a last name input field. The user wants both the first and last name separated by a blank space within the same field.

First name
Last name
Concat() joiner
Concat() returns
JeffMurphy<blank space>Jeff Murphy

Joining Two Street Names Into an Intersection

In this example, there are two street names. The user wants to combine the street names using the joining word "and".

Street1
Street2
Concat() joiner
Concat() returns
BroadwaySeventh Avenue<blank space>and<blank space>Broadway and Seventh Avenue

Hero Platform_ Example

An example of this function can be found in Hero Platform_'s library of examples.

Download the example titled "function_Concat" to see an example of this function. 

Type

Formulas