08-12-2009
Counting
Hi,
I want to count how many rows are in a file for a specific column.
eg.
K NM
K NM
K NM
K JK
K NM
K JK
K NM
so the file is tab-delimited. I want to count how many rows are in column 2 and how many NMs there are.
I used awk
awk '{OFS="\t"}; {count[$2]++} {print i, count[i]}' file
but i cant seem to do it for NMs only.
thanks
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all. If I have a unix directory with multiple files, lets say, I have some with .dat extensions, some with .txt extensions, etc etc.
How in a script would I provide a count of all the different file types (so, the different extensions, I guess) in the directory??
So if I had:
test.dat... (6 Replies)
Discussion started by: gerard1
6 Replies
2. IP Networking
there are a number of clients connected to a server.... how can i count that each clients recieve ...? how do i moniter the activity of the client..? (2 Replies)
Discussion started by: damn_bkb
2 Replies
3. Shell Programming and Scripting
Hello,
I am trying to write a shell script, but i encountered a problem I cant solve alone so I hope you guys can help me. The situation is:
I have a script file and a config file, in my config file I set some Variables:
for example:
destination=(xp, xq, xt)
username=testor... (3 Replies)
Discussion started by: Kenada
3 Replies
4. UNIX for Dummies Questions & Answers
if i have a long list of data, with every line beginning with an ip-address, like this:
62.165.8.187 - - "GET /bestandnaam.html HTTP/1.1" 200 5848 "http://www.domeinnaam.nl/bestandnaam.html" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)"
how do i count which ip-adresses are mentioned... (3 Replies)
Discussion started by: FOBoy
3 Replies
5. Shell Programming and Scripting
Hi
Is there a way to count the no. of words in all files in directory. All are text files.I use wc -w but somehow i am not getting the rite answer.
Is there an alternative.
Thanks in advance (9 Replies)
Discussion started by: kinny
9 Replies
6. Shell Programming and Scripting
Hi,
The following output shows how many pmon process are started by users named : oracle or yoavb
$ ps -ef |grep pmon |grep -v grep |grep -v ipmon
oracle 11268 1 0 Sep 2 ? 36:00 ora_pmon_qerp
oracle 17496 1 0 Oct 11 ? 8:58 ora_pmon_bcv
oracle 15081 1 0 ... (5 Replies)
Discussion started by: yoavbe
5 Replies
7. Shell Programming and Scripting
Hi,
I want to perform a task using shell script. I am new to awk programming and any help would be greatly appreciated.
I have the following 3 files (for example)
file1:
Name count Symbol
chr1_1_50 10 XXXX
chr3_101_150 30 YYYY
File2:
Name ... (13 Replies)
Discussion started by: Diya123
13 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I promise this is my very last dumb question.. but how to you count how many unique names you have.
My dataset is:
>Bac1
afdsgrr
>Bac4
egege
>Bac8
dgrjh
>Bac1
afdsgrr
>Bac1
afdsgrr
>Bac8
dgrjh
What i want to know is that how many unique names there is, so the output would... (3 Replies)
Discussion started by: Iifa
3 Replies
9. Shell Programming and Scripting
Hi have a file of the following format
a1
a1
a2
a2
a4
a4
a4
a3
a3
a5
a6
a6
a6
a6
..
100's of lines (2 Replies)
Discussion started by: Lucky Ali
2 Replies
COLRM(1) BSD General Commands Manual COLRM(1)
NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
awk(1), column(1), cut(1), paste(1)
HISTORY
The colrm command appeared in 3.0BSD.
BSD
August 4, 2004 BSD