Teadmistebaas

  1. Portaali avaleht
  2. Teadmistebaas
  3. Scripts
  4. Linux - How to combine multiple .csv files

Linux - How to combine multiple .csv files

To combine multiple files with the letters "2014" and "2015" in their name run the following command

cat 2014*.csv 2015*.csv > combined.csv

You may want to take a look at our guide on splitting files into X amount of MB after doing this.

Kas see vastus oli kasulik?

 Prindi artikkel

Loe veel

Linux - How to only keep X data

Firstly to start this you need to convert your .csv into a .txt mv filename.csv  filename.txt...

Linux - Only keep certain country data

< FileToExtract.csv awk 'BEGIN {FS=","} tolower($19)~/usa|united states/' > USAList.txtThis...

Linux - Delete lines with duplicate data

If for example you dont want the same email address to be in your .csv files you would run the...

Linux - How to split large file

For this example we will split a large .csv into multiple files each "X" megabytes in size....

Linux - Download files through FTP

To download all files recursively run the following command. wget -nc -np --reject "index.html*"...