ajBigStrTextSplit function
Description
Splits Big String text with a sdelimiter.
Syntax
ajBigStrTextSplit(memory_id, delimiter, [run_condition], [run_by_function_point_only])
| Argument Name | Argument Type | Description |
|---|---|---|
| memory_id (big string ID) (required) | String | The memory address id that keeps the Big String text. A big string ID can be retrieved from ajBigStrSet() or configure Big String value from More Tools tab in AlchemyJ ribbon. |
| delimiter (required) | String | Character or string to split the text. |
| 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:
- Return Value: A list of split Big String
- Return Type: Single Value / Multiple values (array formula)
Example
In this example, we will demonstrate how to split Big String text with a delimiter.
The Big String value we have set in the B1 is '111,222,333' and the delimiter is comma ','.
Select a range, for example, B7 to B14, input the formula as shown in Cell B6 and press CTRL + SHIFT + ENTER to make it to be an array formula since it returns a list of Big String ID. Both vertical and horizontal array formula are supported.
To verify the result, we can use the ajBigStrValue formula in Cell C7 to C9 to make it to show the value. As seen in Cell C7 to C9, the text set in B1 was split with comma.
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type.