Skip to content

Instantly share code, notes, and snippets.

out.dat
* record1_column1_value, record2_column1_value, record3_column1_value, ... (for all records)
* record1_column2_value, record2_column2_value, record3_column2_value, ... (for all records)
* record1_column3_value, record2_column3_value, record3_column3_value, ... (for all records)
* ... (for all columns sorted alphabetically)
* Little endian encoding.
out.mdat
* column_name (36 bytes), type (1 byte), size (2 bytes), offset (8 bytes)
* column_name (36 bytes), type (1 byte), size (2 bytes), offset (8 bytes)
usage: java -jar csv_kit.jar [-?] [-dcn <arg>] [-icsv <arg>] [-mcsv <arg>] [-oci <arg>] [-ocn <arg>] [-ocs <arg>] [-ocsv
<arg>]
CSV kit
-?,--help Print this message
-dcn,--delete-columns-names <arg> Columns' names (comma separated) to delete from the output CSV file (optional)
-icsv,--input-csv-file <arg> Input CSV file with path (required)
-mcsv,--merge-csv-file <arg> CSV file to be merged with input-csv-file (optional)
-oci,--order-column-increment <arg> Column increments for the order column to be added (optional, default: 1)
-ocn,--order-column-name <arg> Column name for the order column to be added (optional)
-ocs,--order-column-start <arg> Column start value for the order column to be added (optional, default: 1)
CSV Geocoder
-?,--help Print this message
-f,--format <arg> Output format of geocoded values (optional, default: WKT)
Possible values:
- WKT e.g. "POINT (-73.92578 40.839233)"
- latlong e.g. "40.839233,-73.92578"
-icn,--input-column-name <arg> Input column name to geocode (required)
-icsv,--input-csv-file <arg> Input CSV file with path (required)
-ocn,--output-column-name <arg> Output column name for geocoded values (required)
-ocsv,--output-csv-file <arg> Output CSV file with path (optional, default: same as input)