current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems.. It's 100% free, no registration required.
up vote 2 down vote favorite

I have 6 columns, each with multiple rows.

I want to count the number of rows which have the integer 4 or 5 in the fifth column. 

A1 jhfj jdhfjkhd kdkfjjh 5 jhsdjkfh
A2 ujhf jhdfhsd  dsfkks  4 jhsdfjhs
A3 jhfj jdhfjkhd kdkfjjh 5 jhsdjkfh
A4 jhfj jdhfjkhd kdkfjjh 5 jhsdjkfh
A5 ujhf jhdfhsd  dsfkks  4 jhsdfjhs

In the example presented, the result should be three for lines with a 5, and two for lines with a 4.

share|improve this question
    
You mean that you want rows that do not contain 4 or 5 in the 5th column? –  devnull Feb 13 at 8:25
1  
Skipping lines with 4 or 5 in the 5th column, what do you want to count? Number of lines, sum of the line lengths, sum of the 5 the column values, total number of columns? –  Zelda Feb 13 at 8:37
1  
@Zelda I assume the OP meant "No.", not "no". –  Chris Down Feb 13 at 8:45
    
@ChrisDown That could be, on reread I still can't figure out what is that "which has" refers to. I would assume someone using nr. in that case anyway. –  Zelda Feb 13 at 8:55
1  
@Zelda Standard British notation is "No." -- the OP's name (from the username) is "Taraka Ramji", a typically Indian name, and India tends towards using British abbreviation conventions. I'm just guessing here :-) –  Chris Down Feb 13 at 8:59

4 Answers 4

up vote 2 down vote accepted

Using only awk:

awk '
  $5==4{c4++};
  $5==5{c5++};
  END{
    print "Fours: "c4;
    print "Fives: "c5;
  }' your_file

or perl:

perl -lane '
  $count{$F[4]}++;
  END{
    print "Fours: $count{4}";
    print "Fives: $count{5}"
  }' your_file
share|improve this answer
up vote 2 down vote

This will give you the gross counts for rows with a 4 and rows with a 5 in the 5th column.

$ awk '{print $5}' somefile | sort | uniq -c
      2 4
      3 5

The counts the first digit in the output, the 2nd column is which number it corresponds to from the 5th column.

share|improve this answer
    
Note to the OP: this assumes all rows have either a 4 or a 5 in the fifth column; otherwise, it will print counts for other values in the fifth column as well. –  Joseph R. Feb 16 at 10:10
up vote 0 down vote

Following execution will lead you to your required output.

1) awk '{print $5}' 4.txt | grep -c 4

2) awk '{print $5}' 4.txt | grep -c 5

3) awk '{print $5}' 4.txt | sort | uniq -c

Explanation:

-c option will count the no. of pattern matched in all above cases

share|improve this answer
up vote -1 down vote 
cat file | awk '{print $1,$2,$3,$4,$6}'

output is:

A1 jhfj jdhfjkhd kdkfjjh jhsdjkfh
A2 ujhf jhdfhsd dsfkks jhsdfjhs
A3 jhfj jdhfjkhd kdkfjjh jhsdjkfh
A4 jhfj jdhfjkhd kdkfjjh jhsdjkfh
A5 ujhf jhdfhsd dsfkks jhsdfjhs

there is no 5 and 4 in the lines in th 5th column. From your post I hope that you requested like this.

share|improve this answer
    
So what it is that is being counted (as requested by the OP)? –  Zelda Feb 13 at 8:57
    
awk takes the filename as an argument: no need for UUOC... –  jasonwryan Feb 13 at 9:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.