База знань

  1. Головна
  2. База знань
  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

Ця відповідь Вам допомогла?

 Роздрукувати цю статтю

Також прочитайте

Linux - How to split large file

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

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 - Delete .csv column

Before you start you need to install Ubuntu - sudo apt-get install libtext-csv-perl CentOs -...

Linux - How to combine multiple .csv files

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

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