The Concat function combines two or more separate text values into one. Concat performs the same function as Jointext, but is simpler to use.

Concat - short for concatenation - joins two or more strings together into a single string.

As with Jointext, leading spaces in strings are retained, but trailing spaces are truncated.

Any number of fields or strings. Fields will automatically be converted to correctly formatted strings by ConCat, so you can create a string from any DataEase fields this way. 

If you want to input a fixed value this value need to be quoted "my string".

Example 1

Concat("My ", "name", " is", " Dave")

Result:  My name is Dave

Example 2

Concat("The time is: ",current time," and the Date is: ", current date)

Result: (Now!): The time is: 20:44:03 and the Date is: 10/12/2012

Concat

Type

Text Function

Purpose

The Concat function combines two or more separate text values into one. Concat performs the same function as Jointext, but is simpler to use. Concat - short for concatenation - joins two or more strings together into a single string.

As with Jointext, leading spaces in strings are retained, but trailing spaces are truncated.

Syntax

Concat (textstring1, textstring2?.textstringn).

? where textstringn continues as many times as you require

Returns

A text value up to 255 characters in length.

Example

Concat("My ", "name", " is", " Dave".

? would produce the string "MyName is Dave"

Notice that "MyName" has no space, because the trailing space in "My " was truncated. Whereas the words "Name is" are correctly spaced, because the string " is" had a leading space.

The Jointext function is retained, and can still be used.