Knowledgebase

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

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

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

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

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

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

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

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

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