EVL – ETL Tool


Products, services and company names referenced in this document may be either trademarks or registered trademarks of their respective owners.

Copyright © 2017–2022 EVL Tool, s.r.o.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.

Table of Contents

Float and Double

Float and double are standard C++ data types.

float

size: 4 Bytes, range: ± 3.4 × 10±38 (about 7 digits)

double

size: 8 Bytes, range: ± 1.7 × 10±308 (about 15 digits)

Except ‘sep=’, ‘null=’, ‘quote=’, ‘optional_quote=’, no other options are possible for these data types.

Note: Compared to decimal(m,n) data type, operating with floats and doubles (doing summations for example), usually leads to approximated values. So it is usually very good idea to avoid using these data types for money and such.

Example

With EVD file

sent_mb      float  sep="|"  null=""
received_mb  float  sep="\n" null=""

you can read source csv file like this:

0.321e12|1.234E-02
12.78E11|3.798