Base de Conhecimento
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
If you only wanted to keep fields that contain the word "dogs" or "cats" then you would run the following. $1 represents the field number
< filename.txt awk 'BEGIN {FS=","} tolower($1~/dogs|cats/' > newfilename.txt
If you also want to keep X data in either of the first or second columns you can run this command (replace smith and john with your keywords)
< filename.txt awk 'BEGIN {FS="\",\""} tolower($1~/smith|john/||$2~/smith|john/' > newfilename.txt