ajBigStrTextJoin function
Description
Concatenates a list or range of Big String text using a delimiter.
Syntax
ajBigStrTextJoin(delimiter, ignore_empty, text, [run_condition], [run_by_function_point_only])
| Argument Name | Argument Type | Description |
|---|---|---|
| delimiter (required) | String | Character or string to insert between each text item. |
| ignore_empty (required) | Boolean | TRUE - ignore empty cells. FALSE - include empty cells |
| text (required) | Range | It is a cell range that contains the texts to be joined. |
| run_condition (optional) | Boolean | The function will run when the value is TRUE. Otherwise will not run. The default value is TRUE. |
| run_by_function_point_only (optional) | Boolean | If it equals FALSE, the function can be executed through ‘Excel Calculation’ (can be either Automatic or Manual, Calculate Now or Calculate Sheet) or Preview Function Point. If it equals TRUE, the function can be executed with Preview Function Point (AlchemyJ ribbon \ Preview Function Point) only. The default value is TRUE. |
The function will return:
1) Return Value: Big String
2) Return Type: Single Value
Example
In this example, we will demonstrate how to concatenate a range of Big String text using a delimiter.
The Big String values we have used here are 'abc' and 'def'. The delimiter we have used here is '#'.
We can use the formula as shown in Cell B7 and it will return a Big String value.
To verify the result, we can use the ajBigStrValue formula in Cell B9 to make it into a normal String. As seen in Cell B10, we have successfully concatenate 'abc' and 'def' with a delimiter '#' to become 'abc#def'.
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type.