Use to split column data using delimiters comma (",) and dash ("-") and stack column data.
ix=[book1]1!col(1) name="Name" subcat=0 first="Last" second="First" include=[book1]1![2:end] rd=[Result]1!
Please refer to the page for additional option switches when accessing the x-function from script
| Display Name |
Variable Name |
I/O and Type |
Default Value |
Description |
|---|---|---|---|---|
| Column to be Split | ix |
Input vector |
|
Column to be split. |
| Subcategory Name | subcat |
Input int |
|
Subcategory name. If full name (0) is specified, the full name should be taken. If sub-name (1) is specified, only the latter part after the delimiter ("," or "-") should be taken. |
| Split Column Name | name |
Input string |
|
Long name of the result column. |
| First Part Name | first |
Input string |
|
If specified, will put into Long Name and fill column with 1=first part, 0=second part. |
| Second Part Name | second |
Input string |
|
If specified, will put into Long Name and fill column with 0=first part, 1=second part |
| Include Other columns | include |
Input Range |
|
Other columns to be included in the output (see wstackcol). |
| Report Data | rd |
Output string |
|
Report data as output. |