Preguntes Freqüents - FAQ

  1. Administració
  2. Preguntes Freqüents - FAQ
  3. Scripts
  4. Linux - Delete lines with duplicate data

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 following command to
awk '!x[$2]++' FS="," FILENAME.csv > newname.csv

FILENAME.csv needs to be replaced with your .csv file and [$2] needs to be edited to represent the line you want to check for duplicate content.

Ha estat útil la resposta?

 Imprimeix aquest Article

Llegir també

Linux - Delete .csv column

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

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

Linux - Only keep certain country data

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

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