Numeric Data

BOOLEAN

Matches case insensitive strings true and false

output type:BOOLEAN
quantifier:none
configuration:none

Example:

true
FALSE
TrUe
1
BOOLEAN:b EOL

Results in all rows parsed to BOOLEAN field b.

FLOAT

Matches floating point numbers in the form of [+|-]?[0-9]+[.0-9]* (dot “.” separated) or [+|-]?[0-9]+[E|e0-9]* (scientific notation)

output type:

FLOAT

quantifier:

none

configuration:

min =min_value : the minimum of parsed value. If the value is less then parsing fails and the output is set to NULL.

max =max_value : the maximum of parsed value. If the value is greater then parsing fails and the output is set to NULL.

Example:

3e0

1
0.1

Following pattern enforces parsed FLOAT value to be between 1.0 and 3.0. Adding Optional Modifier ‘?’ allows empty fields (evaluated to NULL):

1
FLOAT(min=1, max=3)?:f EOL

Parsing results values in rows 1-3 extracted to FLOAT field f. Value in line 4 fails parsing as it is less than specified minimum:

f _unmatched
3.0 NULL
NULL NULL
1.0 NULL
NULL {pos=7 len=3 data=’0.1’}

CFLOAT

Same as FLOAT, but with separator comma “,” : [+|-]?[0-9]+[,0-9]* or [+|-]?[0-9]+[E|e0-9]*

DOUBLE

Matches floating point numbers in the form of [+|-]?[0-9]+[.0-9]* (dot “.” separated) or [+|-]?[0-9]+[E|e0-9]* (scientific notation)

output type:

DOUBLE

quantifier:

none

configuration:

min =min_value : the minimum of parsed value. If the value is less then parsing fails and the output is set to NULL.

max =max_value : the maximum of parsed value. If the value is greater then parsing fails and the output is set to NULL.

CDOUBLE

Same as DOUBLE, but with separator comma: [+|-]?[0-9]+[,0-9]* or [+|-]?[0-9]+[E|e0-9]*

INT, INTEGER

Matches integral numbers in the range -2147483648 to 2147483647

output type:

INTEGER

quantifier:

none

configuration:

min =min_value : the minimum of parsed value. If the value is less then parsing fails and the output is set to NULL.

max =max_value : the maximum of parsed value. If the value is greater then parsing fails and the output is set to NULL.

Example:

1-10+20

Pattern:

1
INT:i

Parsing results in extracting three integer values from line 1:

i _unmatched
1 NULL
-10 NULL
20 NULL

HEXINT

Matches integral numbers in hexadecimal notation: [+|-]?0?x?[0-9a-fA-F]+ with values in the range -2147483648 to 2147483647

output type:

INTEGER

quantifier:

none

configuration:

min =min_value : the minimum of parsed value. If the value is less then parsing fails and the output is set to NULL.

max =max_value : the maximum of parsed value. If the value is greater then parsing fails and the output is set to NULL.

Example:

0xa01F
-xFE
10fE

Pattern:

1
HEXINT:h EOL;

Parsing results values in lines 1-3 parsed into INTEGER field h:

h _unmatched
40991 NULL
-254 NULL
4350 NULL

LONG

Matches integral numbers in the range -18446744073709551615 to 18446744073709551614

output type:

LONG

quantifier:

none

configuration:

min =min_value : the minimum of parsed value. If the value is less then parsing fails and the output is set to NULL.

max =max_value : the maximum of parsed value. If the value is greater then parsing fails and the output is set to NULL.

Example:

-2000
18446744073709551613

Pattern:

1
LONG:l EOL

Parsing results values in lines 1-2 extracted to LONG field l:

l _unmatched
-2000 NULL
18446744073709551613 NULL

HEXLONG

Matches integral numbers in the hexadecimal notation: [+|-]?0?x?[0-9a-fA-F]+ with values in the range -18446744073709551615 to 18446744073709551614

output type:

LONG

quantifier:

none

configuration:

min =min_value : the minimum of parsed value. If the value is less then parsing fails and the output is set to NULL.

max =max_value : the maximum of parsed value. If the value is greater then parsing fails and the output is set to NULL.