Overview
csvq is a command line tool to operate CSV files. You can read, update, delete CSV records with SQL-like query.
You can also execute multiple operations sequentially in managed transactions by passing a procedure or using the interactive shell. In the multiple operations, you can use variables, cursors, temporary tables, and other features.
Latest Release
- Version 1.13.8
- Released on January 31, 2021
Features
- CSV File Operation
- Cursor
- Temporary Table
- Transaction Management
- Support loading data from Standard Input
- Support following file formats
- CSV
- TSV
- LTSV
- Fixed-Length Format
- JSON
- Support following file encodings
- UTF-8
- UTF-16
- Shift_JIS
JSON Format supports only UTF-8.
Installation
Installation - Reference Manual - csvq
Command Usage
Command Usage - Reference Manual - csvq
Reference Manual
Execute csvq statements in Go
Example of cooperation with other applications
License
csvq is released under the MIT License