csvtk v0.18.0

Changes

• csvtk v0.18.0
  • csvtk: add new flag --ignore-illegal-row to skip illegal rows. #72
  • csvtk summary: add more textual/numeric operations. #64
  • csvtk sort: fix bug for sorting by columns with empty values. #70
  • csvtk grep: add new flag --delete-matched to delete a pattern right after being matched, this keeps the firstly matched data and speedups when using regular expressions. #77

csvtk v0.17.0

Changes

• csvtk v0.17.0
  • new command: csvtk add-header and csvtk del-header for adding/deleting column names. #62

csvtk v0.16.0

Changes

• csvtk v0.16.0
  
  • new command: csvtk csv2json: convert CSV to JSON format.
  • remove comand: csvtk stats2.
  • new command csvtk summary: summary statistics of selected digital fields (groupby group fields), usage and examples. #59
  • csvtk replace: add flag --nr-width: minimum width for {nr} in flag -r/--replacement. e.g., formating "1" to "001" by --nr-width 3 (default 1)
  • csvtk rename2/replace: add flag -A, --kv-file-all-left-columns-as-value, for treating all columns except 1th one as value for kv-file with more than 2 columns. #56

csvtk v0.15.0

Changelog

• csvtk v0.15.0
  
  • csvtk: add global flag -E/--ignore-empty-row to skip empty row. #50
  • csvtk mutate2: add flag -s/--digits-as-string for not converting big digits into scientific notation. #46
  • csvtk sort: add support for sorting in natural order. #49

csvtk v0.14.0

Changelog

• csvtk: supporting multi-line fields by replacing multicorecsv with standard library encoding/csv,
  while losing support for metaline which was supported since v0.7.0. It also gain a little speedup.
• csvtk sample: add flag -n/--line-number to print line number as the first column ("n")
• csvtk filter2: fix bug when column names start with digits, e.g., 1000g2015aug (#44)
• csvtk rename2: add support for similar repalecement symbols {kv} and {nr} in csvtk replace

csvtk v0.13.0

Changelog

• new command concat for concatenating CSV/TSV files by rows #38
• csvtk: add support for environment variables for frequently used global flags #39
  • CSVTK_T for flag -t/--tabs
  • CSVTK_H for flag -H/--no-header-row
• mutate2: add support for eval expression WITHOUT column index symbol, so we can add some string constants #37
• pretty: better support for files with duplicated column names

csvtk v0.12.0

Changelog

• new command collapse: collapsing one field with selected fields as keys
• freq: keeping orignal order of keys by default
• split:
  • performance improvement
  • add option -G/--out-gzip for forcing output gzipped file

csvtk v0.11.0

Changelog

• add command split to split CSV/TSV into multiple files according to column values
• add command splitxlxs to split XLSX sheet into multiple sheets according to column values
• csvtk, automatically check BOM (byte-order mark) and discard it

csvtk v0.10.0

Changelog

• add subcommand xlsx2csv to convert XLSX to CSV format
• grep, filter, filter2: add flag -n/--line-number to print line-number as the first column
• cut: add flag -i/--ignore-case to ignore case of column name

csvtk 0.9.1

Changelog

• csvtk replace: fix bug when replacing with key-value pairs brought in v0.8.0