CONCAT

Syntax:	C part_1 CONCAT C part_2
Return Value:	C result
Precedence:	10
Description:	CONCAT joins two character fields CONCAT can be used in combination with HEAD and TAIL to concatenate parts of a field
Example:	"HE" CONCAT "LLO" = "HELLO" "HELLO " CONCAT (HEAD("JOE BROWN",3)) = "HELLO JOE"

You can create a new character field CUSTOMER_DETAILS, defined as follows:

The CUSTOMER_DETAILS are printed like this:

ANG Aschmeyer J
2 Camsix Chase
Hertford

REPSETUP works through the formula, ignoring carriage returns, and filling each print line. For example, if a field in the formula is 30 characters long, REPSETUP inserts 30 characters. This may result in fields being split over two or more lines. Let's look at the previous example again:

111233333333333333333333333333
333344444444444444444444444444
444455555555555555555555555555

where:

1 is REGION_CODE
2 is " "
3 is NAME
4 is ADDRESS[1]
5 is ADDRESS[2]