Easy to Create, Easy to Change - Easy to use!

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

On the blog about JoinText