Register
Sign In
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.
TEXT VALUE
Any text or DataEase field value except Memo.
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
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
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.
Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32
Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17
Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11
Product: . Written by Marco Marchesi 15/02/16 at 14:50:46
Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46
Product: . Written by afonso santos 28/10/19 at 00:50:14
Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44
Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10
Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40
Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10
Copyright © DataEase Limited. All Rights Reserved
