2.2.39 wxcat


Brief Information

Use to split column data using delimiters comma (",) and dash ("-") and stack column data.

Command Line Usage

ix=[book1]1!col(1) name="Name" subcat=0 first="Last" second="First" include=[book1]1![2:end] rd=[Result]1!

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Column to be Split ix

Input

vector

<active>

Column to be split.

Subcategory Name subcat

Input

int

0

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

<optional>

Other columns to be included in the output (see wstackcol).

Report Data rd

Output

string

<new>

Report data as output.