05-15-2008
awk - counting number of similar lines
Hi
Thanks for the information provided.
I read the source code that you have proivded. For eg I have the below said data.
SIZEC000002EXCLUDE 1341
SIZEC000002EXCLUDE 1341
SIZEC000002EXCLUDE 1341
SIZEC000003EXCLUDE 1341
SIZEC000003EXCLUDE 1341
SIZEC000003EXCLUDE 1341
SIZEC000004EXCLUDE 1341
SIZEC000004EXCLUDE 1341
SIZEC000004EXCLUDE 1341
SIZEC000004EXCLUDE 1341
SIZEC000005EXCLUDE 1341
SIZEC000005EXCLUDE 1341
SIZEC000005EXCLUDE 1341
I have two questions
a] What is the purpose of having these statements if input is the above said data
split($2, m, /[A-Z]+/)
split($2, n, /[0-9]+/)
as $2 will not have any values of alphabets.
OR is it necessary to have both m and n.
b] If i have the below data
SIZEC000004EXCLUDE 1380
SIZEC000004EXCLUDE 1382
SIZEC000005EXCLUDE 1340
SIZEC000005EXCLUDE 1341
SIZEC000005EXCLUDE 1342
I want to group the datas like the below
SIZEC000004EXCLUDE 1380 1382
SIZEC000005EXCLUDE 1340 1341 1342
Is awk having any standard functions to do it.
Regards
Dhana
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello. First time poster here. I have a huge file of IP numbers. I am trying to output only the class b of the IPs and rank them by most common and output the total # of duplicate class b's before the class b. An example is below:
12.107.1.1
12.107.9.54
12.108.3.89
12.109.109.4
12.109.6.3
... (2 Replies)
Discussion started by: crunchtime
2 Replies
2. Linux
Hello,
I have afile which begins with a few urls on multiple lines and then there is listing of some information on separate lines.
The listing begins with the word Name on a given line followed by teh actual list.
I want to count the number of lines in this file after the line having... (6 Replies)
Discussion started by: nayeemmz
6 Replies
3. Shell Programming and Scripting
Hi all,
I use bash shell and I have a problem with wc.
I would like to determine the number of lines in a file so I do
wc -l filename
but I don't want to get the filename again
I just would like to have the number of lines and use it in a variable.
Can anybody help?
Thank you, (7 Replies)
Discussion started by: f_o_555
7 Replies
4. Shell Programming and Scripting
Hi, I am having the following number in the file tmp
31013.004
20675.336
43318.190
30512.926
48992.559
277893.111
41831.330
8749.113
415980.576
28273.054
I want to add these numbers, I am using following script
awk 'END{print s}{s += $1}' tmp
its giving answer 947239 which is correct,... (3 Replies)
Discussion started by: chaitubek
3 Replies
5. Shell Programming and Scripting
I have a file which contains data as below:
nbk1j7o pageName=/jsp/RMBS/RMBSHome.jsf
nbk1j7o pageName=/jsp/RMBS/RMBSHome.jsf
nbk1j7o pageName=/jsp/RMBS/RMBSHome.jsf
nbk1j7o pageName=/jsp/RMBS/RMBSHome.jsf
nbk1j7o pageName=/jsp/common/index.jsf
nbk1j7o pageName=/jsp/common/index.jsf
nbk1wqe... (6 Replies)
Discussion started by: mohsin.quazi
6 Replies
6. Shell Programming and Scripting
Hi,
I am trying to count the max number of occurences of field1 in my apache log
example:
10.0.0.1 field2 field3
10.0.0.2 filed2 field3
10.0.0.1 field2 field3
10.0.0.1 field2 field3
awk result to print out only the most occurence of field1 and number of occurence
and field1 is... (3 Replies)
Discussion started by: phamp008
3 Replies
7. Shell Programming and Scripting
Hi,
I have a little problem with counting lines. I know similar topics from this forum, but they don't resolve my problem. I have file with lines like this:
2009-05-25 16:55:32,143 some text some regular expressions ect.
2009-05-25 16:55:32,144 some text.
2009-05-28 18:15:12,148 some... (4 Replies)
Discussion started by: marcinnnn
4 Replies
8. Shell Programming and Scripting
/bin/sed -n ';4757335,$ p' | wc -l
/bin/sed -n ';4757335,$ p' | egrep "Failed" | egrep -c "PM late arrrival"
how can i combine the above two sed commands into one? i want to count the number of lines between the specified line number and the end of the file. AND and i want to count how many... (5 Replies)
Discussion started by: SkySmart
5 Replies
9. Shell Programming and Scripting
I want to count lines of a file using AWK (only) and not in the END part like this awk 'END{print FNR}' because I want to use it.
Does anyone know of a way?
Thanks a lot. (7 Replies)
Discussion started by: guitarist684
7 Replies
10. Shell Programming and Scripting
Hey everyone,
I have a bunch of lines with values in field 4 that I am interested in.
If these values are between 1 and 3 I want it to count all these values to all be counted together and then have the computer print out
LOW and the number of lines with those values in between 1 and 3,... (2 Replies)
Discussion started by: VagabondGold
2 Replies
LEARN ABOUT DEBIAN
news::scan::thread
News::Scan::Thread(3pm) User Contributed Perl Documentation News::Scan::Thread(3pm)
NAME
News::Scan::Thread - keep track of threads in a Usenet newsgroup
SYNOPSIS
use News::Scan::Thread;
my $thr = News::Scan::Thread->new($news_scan_article_obj);
DESCRIPTION
This module provides a class whose objects can be used to keep track of threads of discussion in a Usenet newsgroup.
CONSTRUCTOR
new ( ARTICLE )
"ARTICLE" should be a "News::Scan::Article" object or an object of some class derived from "News::Scan::Article".
"new" performs some initialization and returns a "News::Scan::Thread".
METHODS
subject
Returns this thread's subject.
volume
Returns the volume in bytes generated in this thread.
articles
Returns the number of posts to this thread.
header_volume
Returns the volume in bytes of the headers in this thread's articles.
header_lines
Returns the number of header lines in this thread's articles.
body_volume
Returns the volume in bytes of the message bodies of this thread's articles.
body_lines
Returns the number of lines in this thread's message bodies.
orig_volume
Returns the volume in bytes of the original content of this thread's articles.
orig_lines
Returns the number of original lines in this thread's articles.
sig_volume
Returns the volume in bytes of the signatures of this thread's articles.
sig_lines
Returns the number of signature lines in this thread's articles.
SEE ALSO
News::Scan, News::Scan::Article
AUTHOR
Greg Bacon <gbacon@cs.uah.edu>
COPYRIGHT
Copyright (c) 1997 Greg Bacon. All Rights Reserved. This library is free software. You may distribute and/or modify it under the same
terms as Perl itself.
perl v5.10.1 2000-04-13 News::Scan::Thread(3pm)