Matches case insensitive strings true and false
trueFALSETrUe
BOOLEAN:b EOL
Results in all rows parsed to boolean field b.
Matches floating point numbers in the form of [+|-]?[0-9]+[.0-9]* (dot "." separated) or [+|-]?[0-9]+[E|e0-9]* (scientific notation)
3e010.1
Following pattern enforces parsed float value to be between 1.0 and 3.0. Adding optional_modifier '?' allows empty fields (evaluated to NULL):
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 |
|---|
3.0 |
NULL |
1.0 |
NULL |
Same as FLOAT, but with separator comma "," : [+|-]?[0-9]+[,0-9]* or [+|-]?[0-9]+[E|e0-9]*
Matches floating point numbers in the form of [+|-]?[0-9]+[.0-9]* (dot "." separated) or [+|-]?[0-9]+[E|e0-9]* (scientific notation)
Same as DOUBLE, but with separator comma: [+|-]?[0-9]+[,0-9]* or [+|-]?[0-9]+[E|e0-9]*
Matches integral numbers in the range -2147483648 to 2147483647
1-10+20
Pattern:
INT:i
Parsing results in extracting three integer values from line 1:
| i |
|---|
1 |
-10 |
20 |
Matches integral numbers in hexadecimal notation: [+|-]?0?x?[0-9a-fA-F]+ with values in the range -2147483648 to 2147483647
0xa01F-xFE10fE
Pattern:
HEXINT:h EOL;
Parsing results values in lines 1-3 parsed into integer field h:
| h |
|---|
40991 |
-254 |
4350 |
Matches integral numbers in the range -18446744073709551615 to 18446744073709551614
-200018446744073709551613
Pattern:
LONG:l EOL
Parsing results values in lines 1-2 extracted to long field l:
| l |
|---|
-2000 |
18446744073709551613 |
Matches integral numbers in the hexadecimal notation: [+|-]?0?x?[0-9a-fA-F]+ with values in the range -18446744073709551615 to 18446744073709551614