filter a CSV file

imkornhulio · 08-23-2011, 09:06 AM

My CSV file looks like this

Temp,0,Finance,456987
Perm,50,Accounting,895465
Perm,0,MIS,12354
Perm,0,HR,12589

I would like to filter the file and output where the second column is 0

Temp,0,Finance,456987
Perm,0,MIS,12354
Perm,0,HR,12589

I tried using awk with failure

Thank you

Snark1994 · 08-23-2011, 10:13 AM

I think this should work:

Code:

awk 'BEGIN { FS = "," }; {if ($2 == 0) print}' inputfile.txt

anomie · 08-23-2011, 01:23 PM

The previous method is totally legit, but here's a slightly different way to do the same thing:

Code:

$ awk -F"," '{ if ($2 == 0) print }' this.csv

colucix · 08-23-2011, 02:17 PM

Or even shorter:

Code:

awk -F, '$2==0' file

kurumi · 08-24-2011, 07:04 AM

Code:

ruby -F"," -ane  'print if $F[1]=="0"' file