Grep command to read a file

Sherlock · 02-02-2007, 02:39 AM

Hi,

i have a file of the form whose records are of the form

Name,gender,Address,Age

i want to write a script where in i want to check whether there are any individuals whose age>50
and how many such records are there??

colucix · 02-02-2007, 02:52 AM

Code:

gawk -F, 'BEGIN {count=0} {if ($4 > 50) count++ } END {print count}' filename

will print the total number of people older than 50. If you want to print also their Name, you can try

Code:

gawk -F, 'BEGIN {count=0} {if ($4 > 50) {count++ ; print $1}} END {print count}' filename

or to print on one line

Code:

gawk -F, 'BEGIN {count=0} {if ($4 > 50) {count++ ; people[count]=$1}} END {printf "%d ",count ; for (i in people) printf "%s ",people[i]; printf "\n"}'

Sherlock · 02-02-2007, 04:18 AM

Thanks colucix!!!

I will try it...