Description
Concatenates a set of fields identified by a regular expression
Syntax
ConcatenateRegex(<delimiter>,<includeblanks>,<regex>)
Arguments
| Argument | Type | Description | Optional |
|---|---|---|---|
| delimiter | text | Defines a delimiter (e.g. comma, semicolon) to use when concatenating fields | No |
| includeblanks | yes/no | Flag indicating whether to include fields with blank values | No |
| regex | text | Regular expression defining the column names to include in the concatenation | No |
Returns
Text containing concatenated values drawn from the included columns
Examples
| Expression: | ConcatenateRegex(";", false, "Col_\d") |
| Returns: | A;B;C;D |