STRING_CONCAT macro

The STRING_CONCAT macro is available in HCL® Campaign and HCL Interact.

Syntax

STRING_CONCAT(string1, string2,
... stringN)

Parameters

string

An ASCII text string to concatenate. This can be ASCII text in quotes, a column of text, a cell range containing text, or an expression evaluating to any of the above. See the Macro Function Parameters section of the Using Macros chapter for your product for the format definition of string (same as data).

Description

STRING_CONCAT concatenates the ASCII text values in the specified data ranges. It returns one new column for each input column, each containing the concatenated strings from the corresponding rows of strings. This row-by-row calculation produces a result for each row up to the last value of the shortest column.

Note: The total width of each resulting string cannot exceed 255 characters.

HCL Interact also supports the following syntax:

STRING_CONCAT( string1 , string2

,
...

stringN )

For example, STRING_CONCAT('a', 'b', 'c', 'd') is valid.

Examples


`TEMP = STRING_CONCAT("house", "boat")` Creates a new column named `TEMP`, which contains the ASCII text string "`houseboat` ".
`TEMP = STRING_CONCAT(V1, ".")` Creates a new column named `TEMP`, each row containing the ASCII text string in the corresponding row of column `V1` with an appended period.
`TEMP = STRING_CONCAT(V1, V2)` Creates a new column named `TEMP`, each row containing the containing the ASCII text string in column `V1` concatenated with the text string in column `V2`.
`TEMP = STRING_CONCAT(V1:V3, V4:V6)` Creates three new columns named `TEMP`, `VX`, and `VY`. The values in the `TEMP` column are the concatenated strings from the corresponding rows of column `V1` and `V4`, the values of the `VX` column are the concatenated strings from the corresponding rows of column `V2` and `V5`, and the values of the `VY` column are the concatenated strings from the corresponding rows of column `V3` and `V6`.
`TEMP = STRING_CONCAT(V1[5:10]:V2, V3:V4)` Creates two new columns named `TEMP` and `VX`. The values in the `TEMP` column are strings from rows 5-10 of column `V1` concatenated with the rows 1-6 of column `V3`. The values in `VX` are the strings from rows 5-10 of column `V2` concatenated with the rows 1-6 of column `V4`.
`TEMP = STRING_CONCAT('a', 'b', 'c', 'd')` Creates a new column named `TEMP`, which contains the ASCII text string "`abcd` ".

Related Functions


Function	Description
`STRING_HEAD`	Returns the first n characters of each string in the specified data range
`STRING_LENGTH`	Returns the length of each string in the specified data range
`STRING_SEG`	Returns the string segment between two specified indexes
`STRING_TAIL`	Returns the last n characters of each string in the specified data range