Home

CSV SQL Console

This tool is designed to join multiple CSV files into one CSV file with possibility to sort, group and filter data. Based on ODBC "Microsoft text driver (.txt;.csv)" it supports almost all futures of the SQL. Works offline. Does not require Microsoft Access, SQL Server and other heavy tools.

Command line format

# CsvConsole "job file"

Job file format

CsvFilesFolder;SQL File;OutputCsvFile

• CsvFilesFolder - Is folder with CSV files
• SQL File - File with SQL statement which will be applied to set of CSV files in the CsvFilesFolder
• OutputCsvFile - Name of the CSV file to store result of the SQL request. Calculated relatively to CsvFilesFolder

Job file example

Test;MDSvcLatency.sql;out/MDSvcLatency.csv
Test;MDSvcLatencyPerMessage.sql;out/MDSvcLatencyPerMessage.csv
Test;MDSvcFstEntryLatency.sql;out/MDSvcFstEntryLatency.csv

As far as tool uses ODBC driver, it requires schema.ini file. File can be created by Windows ODBC DataSource Administrator. File can be empty. Sample file can be found in the Files section.

Project Members:

• Dmytro Ovdiienko (admin)