_ColumnTypes
Column types determine how column data is sorted and displayed. By default, column data is treated as a text string sorted alphabetically. Some macros, like the SQL and CSV macros, may automatically generate more precise types. When the default behavior is less than optimal for your situation, the columnTypes parameter can be set specifically. This describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry.
Type | Description | Sorting | Total Formatting | Data Formatting |
|---|---|---|---|---|
S | Text string. This is a series of one or more alphanumeric characters, possibly including a letter, number, space, punctuation mark or other special characters. | Alphabetic | ||
I | Integer. This is a numeric field without a fractional component. | Numeric |
| |
F | Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. | Numeric |
| |
FF | Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. Forced formatting of data columns. | Numeric |
|  |
FC | Numeric or float value and may contain numeric separators including a comma for decimal separator and a period for thousands separator. | Numeric |
| |
C | Similar to F with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored. | Numeric |
| |
CC | Similar to FC with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored. | Numeric |
| |
M | Date format in many popular formats. See Advanced Date Sorting for more information. This is the preferred date sorting type. | Date |
| |
D | Date in the browser date format. See Advanced Date Sorting for more information. The D type is available for compatibility with older releases - the M type is recommended. | Date | ||
E | Emoticons or other HTML elements. | Alphabetic on the inner HTML value | ||
X | Indicates to exclude this column from user selectable sorting. | Disabled | ||
. | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '.'. | Numeric on each separated value | ||
: | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by ':'. | Numeric on each separated value | ||
- | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '-'. | Numeric on each separated value | ||
/ | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '/'. | Numeric on each separated value | ||
H | Indicates to hide the column. |
Total formatting - option to format the total row in a user defined way. See Formatting the Auto Total Row for Numeric Columns.
Numeric data formatting - option to format the data rows in a user defined way for numeric columns. See Formatting Options for Numeric Columns.
Date data formatting - option to format the data rows in a user defined way for date columns. See Formatting Options for Date Columns.
Example Use
Column types: S,I,F"0,0",F"$0,0.00"