Description | Concatenate two operands after coercing each operand to a string value |
Syntax | result = operand1 & operand2 |
Remarks | The & operator creates a string result from its two operands. Numeric operands are first converted to string values. Null valued operands are treated as empty strings except in the case where both operands are Null. If both operands are Null, then the result of the operation is also Null. |
Example | The following example uses the & operator to concatenate the contents of two fields with no space between the data. FieldAt("/SOURCE/R1/Field12") & FieldAt("/SOURCE/R1/Field30") The following example uses the & operator to concatenate the contents of three fields with a space between each piece of the data: FieldAt("/SOURCE/R1/First Name") & " " & FieldAt("/SOURCE/R1/Middle Initial") & " " & FieldAt("/SOURCE/R1/Last Name") The following example uses the & operator to concatenate a string of data to the end of the data in an existing field with a space between each piece of the data. FieldAt("/SOURCE/R1/Field2") & " " & FieldAt("/SOURCE/R1/REGION") The following example takes a 10-digit phone number from the ("Phone_Number") source field and converts it to a standard phone number format with dashes (such as 512-459-1308). Left(FieldAt("/SOURCE/R1/Phone_Number"), 3) & "-" & Mid(FieldAt("/SOURCE/R1/Phone_Number"), 4,3) & "-" & Right(FieldAt("/SOURCE/R1/Phone_Number"),4) |