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.