Plug-in Reference — Structures — SPLIT_COLUMN_INFO

# SPLIT_COLUMN_INFO

Used by EE_SPLIT_COLUMN message.

    typedef struct _SPLIT_COLUMN_INFO {
    	UINT cbSize;
    	UINT nType;
    	UINT nFlags;
    	int* anColumns;
    	int nNumOfColumns;
    	int nLimit;
    	LPCWSTR pszSeparator;
    	LPCWSTR pszLocale;
    } SPLIT_COLUMN_INFO;

## Fields

cbSize

Specifies sizeof( SPLIT_COLUMN_INFO ).

nType

You can specify one of the following values.

Value | Meaning
--- | ---
COLUMN_SPLIT_TO_COLUMNS | Splits specified columns by the separator and put them into the right columns.
COLUMN_SPLIT_TO_LINES | Splits specified columns by the separator and put them into the lines beneath.
COLUMN_SPLIT_TO_NONE | Does not split but sort or remove duplicate split strings in specified columns.

nFlags

You can specify a combination of the following values. SORT_ENABLED must be specified to sort split strings, and combine with other flags to specify the sort behavior. SORT_DELETE_DUPLICATE must be specified to remove duplicate split strings.

Value | Meaning
--- | ---
NORM_IGNORECASE | Case is ignored.
NORM_IGNOREKANATYPE | Hiragana and Katakana characters compare as equal.
NORM_IGNORENONSPACE | Nonspacing characters are ignored.
NORM_IGNORESYMBOLS | Symbols are ignored.
NORM_IGNOREWIDTH | The difference between half-width and full-width characters is ignored.
SORT_BINARY_COMPARISON | Fast binary comparison is used to sort. The locale information is ignored.
SORT_DATE | Sorts date and time.
SORT_DELETE_DUPLICATE | Removes duplicate split strings.
SORT_DIGITSASNUMBERS | Digits are sorted as numbers even when sorted by alphabetical order.
SORT_ENABLED | Sorts split strings.
SORT_IGNORE_PREFIX | Leading non-numeric characters are ignored when using Sort Smallest to Largest or Sort Largest to Smallest commands.
SORT_IPV4 | Sorts IPv4 addresses.
SORT_IPV6 | Sorts IPv6 addresses.
SORT_LENGTH | Sorts strings by the number of characters.
SORT_LENGTH_VIEW | Full width characters are treated as 2 characters when using Sort Shortest to Longest or Sort Longest to Shortest commands.
SORT_NUM | Sorts numbers.
SORT_GROUP_IDENTICAL | Groups identical strings when sorted by occurrence. Must be specified with SORT_OCCURRENCE.
SORT_OCCURRENCE | Sorts by occurrence.
SORT_RANDOM | Sorts randomly.
SORT_REVERSE | Sorts in reverse order.
SORT_STABLE | Stable sort is used. The stable sort maintains the relative order of records. The stable sort is usually slower.
SORT_STRINGSORT | Punctuation marks are treated the same as symbols.
SORT_TEXT | Sorts text.
SORT_WORDS | Sorts strings by the number of words.
SPLIT_DONT_DISCARD_EXTRA | Does not discard extra split strings when nLimit is not 0.

anColumns

Specifies the array of integers containing zero-based column indexes.

nNumOfColumns

Specifies the number of columns specified in anColumns.

nLimit

Specifies the maximum number of splits per cell.

pszSeparator

Specifies a string as a separator when splitting columns.

pszLocale

Specifies the locale used to sort. If this is empty, the locale specified in the Customize dialog box is used.

## Version

Supported on Version 19.9 or later.