Data Type
In Parser Management, you can set the data type for each column. There are four data types:
- Text - The Data Type of each column is Text in default.
- IPv4 – The column content is IP address with the format “a.b.c.d” which each letter represents a number (0-255).
- Numeric – The column content is expressed in numbers. It can be an integer or decimal.
- Date&Time – The column content is date or time. When the data type is Date&Time, click 'Format…' to open Date & Time Format dialog, the format string must be set correctly, as the example is exactly the same with the column content.
The format string expressed as following:
Expression | Character | Description |
---|---|---|
Year | Y | Year with century, as decimal number |
y | Year without century, as decimal number (00 – 99) | |
Month | m | Month as decimal number (01 – 12) |
B | Full month name | |
b | Abbreviated month name | |
Day | d | Day of month as decimal number (01 – 31) |
Time | H | Hour in 24-hour format (00 – 23) |
h | Hour in 12-hour format (01 – 12) | |
M | Minute as decimal number (00 – 59) | |
S | Second as decimal number (00 – 59) | |
s | Millisecond as decimal number (000 – 999) | |
p | A.M./P.M. indicator for 12-hour clock |
When the format string uses “B”/”b” to descript Month, be sure the language is chosen properly. If there is no proper language presented, you can click 'Setup…' to create a set of month name in other language.
Tip: If the example in Date & Time Format dialog is not the same with the column content, the data type won’t be recognized correctly, which may affects the filtering result.