Skip to main content
GrN.dk

Main navigation

  • Contact
  • Your Digital Project Manager
  • About Greg Nowak
  • Services
  • Portfolio
  • Container
    • Excel Freelancer
    • Kubuntu - tips and tricks
    • Linux Apache MySQL and PHP
    • News
    • Image Gallery
User account menu
  • Log in

Breadcrumb

  1. Home

CSV Kit Notes Tips and Examples

Nice thing to use when working with CSV-files is CSV Kit.

See the file statistics: csvstat -e UTF-16 test.csv

Merge all files in a folder: csvstack -e UTF-16 -t *.csv > all.csv

Save column 2 to output .csv: csvcut -c 2 -e UTF-8 all.csv > output.csv

Remove duplicates:

Sort the file first: sort -n output.csv > sorted.csv

Save only unique values: uniq -u sorted.csv > unique.csv

 

 

 

 

 

Last modified
2017-06-13

Tags

  • Linux
  • csv
  • Data
  • Log in to post comments

Review Greg on Google

Greg Nowak Google Reviews

 

  • Portfolio
  • About Greg Nowak
  • Gregs IT and Logistics Optimization
  • Shrink PDF In Linux
  • Running Linux on T450s T495s T14, Thinkpads and Others
RSS feed

GrN.dk web platforms, web optimization, data analysis, data handling and logistics.