Simplicty and flexibility!


Function::String

JoinText
Jointext(TEXT VALUE, TEXT VALUE)
Jointext(TextField,NumberField)
Jointext("This is my name: ", current user name)


The jointext function combines two separate text values into one. 

When two text values are joined, leading spaces are maintained but trailing spaces are deleted. To join three or more fields, you can use additional jointext functions as either or both parameters.

Parameters


TEXT VALUE

Any text or DataEase field value except Memo.

Returns/Result


A text value up to 255 characters in length.

Examples


Examples

jointext( "Sapph" , "ire" )

Returns: Sapphire


jointext( jointext( "Sapph" , "ire" ) , "International" )

Returns: Sapphire International.


In the above example, there is a space at the start of the string International.

jointext( PRODUCT , " for Windows" )

Returns: DataEase for Windows


In the above example, there is a space at the start of the string for Windows. The PRODUCT field holds the value 


Reference

jointext

Type

Text Function

Purpose

The jointext function combines two separate text values into one.

Syntax

jointext( TEXT VALUE1, TEXT VALUE2)

Returns

A text value up to 255 characters in length.

Usage

When two text values are joined, leading spaces are maintained but trailing spaces are deleted. To join three or more fields, you can use additional jointext functions as either or both parameters.

Examples

jointext( "Sapph" , "ire" )

Returns: Sapphire

jointext( jointext( "Sapph" , "ire" ) , "International" )

Returns: Sapphire International.

 

In the above example, there is a space at the start of the string International.

 

jointext( PRODUCT , " for Windows" )

Returns: DataEase for Windows

 

In the above example, there is a space at the start of the string for Windows. The PRODUCT field holds the value DataEase.

See Also


ConCat
MemoCopy
MemoMemoCopy

On the forum about JoinText

[@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 JoinText


dg3_HelpView