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.