Numeric Data

BOOLEAN

Matches case insensitive strings true and false

Example

1true
2FALSE
3TrUe

1BOOLEAN: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)

Example

13e0
2
31
40.1

Following pattern enforces parsed float value to be between 1.0 and 3.0. Adding optional_modifier '?' allows empty fields (evaluated to NULL):

1FLOAT(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:

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)

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

Example

11-10+20

Pattern:

1INT:i

Parsing results in extracting three integer values from line 1:

HEXINT

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

Example

10xa01F
2-xFE
310fE

Pattern:

1HEXINT:h EOL;

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

LONG

Matches integral numbers in the range -18446744073709551615 to 18446744073709551614

Example

1-2000
218446744073709551613

Pattern:

1LONG:l EOL

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

HEXLONG

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