exists 4 times or more

[ng1]

I have a file like this:

111 aa 100.00
111 aa 205.00
totals 2 205.00
111 292.00
111 355.00
222 aa 350.00
totals 1 350.00
222 698.00
3333 aa 497.00
3333 aa 100.00
totals 2 597.00

I want to only print the records that have $1 show up at least 4 times. In this case, I would want to print:

111 aa 100.00
111 aa 205.00
totals 2 205.00
111 222.00
111 355.00

How would I do this? Thanks.

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ng1]

I tried this:

{
if ($1 ~ /^[0-9]+$/)
i=$1

while (i >= 4) {print $0}
}


but it just kept printing the first field over and over again until I stopped it.