Base de connaissances

  1. Accueil
  2. Base de connaissances
  3. Scripts
  4. Linux - How to delete .csv file containing "X" data

Linux - How to delete .csv file containing "X" data

After extracting the .csv.gz files you can delete certain unwanted data by running the following

sed -i '/PROXY/d' filename.csv

That command will delete any lines that contain the word "PROXY"

To delete it for lots of files at once run the following

sed -i '/PROXY/d' *.csv

Cette réponse était-elle pertinente ?

 Imprimer cet article

Consulter aussi

Linux - How to extract .gz files (gunzip)

For this guide we will be using gunzip. You may need to installed it.CentOS - yum install gunzip...

Linux - Download files through FTP

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

Linux - Only keep certain country data

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

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 - 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...