Simplicty and flexibility!


Function::String

ConCat
ConCat(Field1,Field2,....,FieldN)
ConCat(texststring1,texststring2,....,texstringN)


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.


Parameters


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".

Returns/Result


Text String up to 255 characters long.

Examples


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



Reference

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.

See Also


JoinText
MemoCopy
MemoMemoCopy

On the forum about ConCat

[@EOF@]...

Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

How can i delete a Style sheet?...

Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10

I run W7 and since a few days&nbsp;Dataease 8.5 is not starting any more, do you have an idea? i installed it again but that did not help....

Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40

[@EOF@]...

Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10

On the blog about ConCat


dg3_HelpView