Biblioteca de cunoștințe

  1. Portalul clienților
  2. Biblioteca de cunoștințe
  3. Scripts
  4. Linux - Only keep certain country data

Linux - Only keep certain country data

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

This will only keep countries listed as USA/United States. It is not case sensative.

$19 represents the column number.

You can keep multiple countries by modifying the command, for example

/usa|united states|spain|germany/

Răspunsul a fost util?

 Tipărire

V-ar mai putea interesa și

Linux - How to combine multiple .csv files

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

Linux - Delete .csv column

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

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

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 - How to split large file

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