CSV

CSV files are a little bit like like dates: superficially simple, with lots of corner cases. Largely for the same reason: not in accordance with standard.

• RFC 4180 - Common Format and MIME Type for Comma-Separated Values (CSV) Files

• CSV.js/csv.js at master · knrz/CSV.js

• CSV Project - Node.js CSV package

• awk

  • Awk-Batteries/Units/csv at master · Nomarian/Awk-Batteries

  • Awk-Batteries/csv.awk at master · Nomarian/Awk-Batteries - parse CSV gawk -f "$AWK/Units/csv.awk" -e '{print NF}'

  • What's the most robust way to efficiently parse CSV using awk? - Stack Overflow

• How to convert arbitrary simple JSON to CSV using jq? - Stack Overflow

• sqlite3 cities.db ".mode csv" ".import ./city.csv cities" ".exit" Command Line Shell For SQLite

• johnkerl/miller: Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

• BurntSushi/xsv: A fast CSV command line toolkit written in Rust.

• harelba/q: q - Run SQL directly on CSV or TSV files

• wireservice/csvkit: A suite of utilities for converting to and working with CSV, the king of tabular file formats.

Alternative formats

• Tab-separated values - Wikipedia

• Text File formats – ASCII Delimited Text – Not CSV or TAB delimited text | Ronald Duncan's Blog