roskakori / cutplace

validate data stored in CSV, PRN, ODS or Excel files
http://cutplace.readthedocs.org/
GNU Lesser General Public License v3.0
18 stars 20 forks source link

Add option to build SQL*Loader control files #100

Open roskakori opened 9 years ago

roskakori commented 9 years ago

Goal: cutplace --sql sqlldr some_icd.ods buils a script that can be passed to sqlldr to load data conforming to the CID into a table.

sqlldr documentation:

Note that control files cannot express that the last field in a CSV can be empty; it either has to be empty all the time or never. Consequently cutplace must fail if the last field has x in the Empty? column but is not a ConstantFieldFormat