CSV Utils

• Manual and Complete Zip:

  • Manual (PDF)
  • Zip of all files (Zip)

• Linux Binaries of Programs:

  • csv-cat: "cat" (print out and concatenate) one or more CSV files
  • csv-clean: "clean" a CSV file (unquoting fields, removing embedded CR's and LF's, and/or fixing field counts in records)
  • csv-counts-fields: print out field counts for the records
  • csv-counts-records: print records counts for one or more CSV files
  • csv-cut: "cut" (print out) specific fields from the records, to reduce dimensionality
  • csv-edit: replace the value of one field in one record
  • csv-format: produce readable, columnized text version of a CSV file
  • csv-grep: "grep" a field, to select records with field matching a pattern
  • csv-grep-cond: "grep" a field, to select records with field meeting a condition
  • csv-grep-cond-records: "grep" entire records, to select records meeting a condition
  • csv-join: append records from a second CSV file onto the records from a base CSV file, based on having matching values in fields of the records
  • csv-paste: append records from a second CSV file onto the records from a base CSV file, based on record order
  • csv-print: print out the fields of one record, using separate lines for readability
  • csv-process-field: process/modify a field of the records, using AWK code
  • csv-process-records: process/modify entire records, using AWK code
  • csv-records: print out a range of records
  • csv-reformat-date-time: reformat date-time values in a field of the records
  • csv-remove-duplicate-keys: remove records with duplicate key values
  • csv-replace-field: apply search-replace patterns to a field of the records
  • csv-sort: sort records based on the values in a single field
  • csv-sort-mult: sort records based on the values in multiple fields
  • csv-validate: validate a CSV file's syntax and get stats on various properties

• Utility Programs to call from Shell Scripts and/or Pipelines:

  • csv-get-field: print out a single field the from next record
  • csv-get-record: print out the next record
  • csv-names2nums: convert list of field names to field numbers

• Programs to Convert Between CSV and Alternative DSV formats:

  • csv-to-dsv: convert CSV file to DSV file with alternative delimiter char
  • dsv-to-csv: convert DSV file with alternative delimiter char to CSV file

• Shell Script Utilities:

  • null2lf: use in pipeline to convert null/zero record terminators back to LFs

Last Updated: 7/17/2022