awk - Counting number of similar lines Post: 302194871

Sponsored Content

Top Forums Shell Programming and Scripting awk - Counting number of similar lines Post 302194871 by dhanamurthy on Tuesday 13th of May 2008 11:26:49 PM

05-14-2008

Registered User

awk - Counting number of similar lines

Hi All

I have the input file OMAK_11.

OMAK 000002EXCLUDE 1341
OMAK 000002EXCLUDE 1341
OMAK 000002EXCLUDE 1341
OMAK 000003EXCLUDE 1341
OMAK 000003EXCLUDE 1341
OMAK 000003EXCLUDE 1341
OMAK 000004EXCLUDE 1341
OMAK 000004EXCLUDE 1341
OMAK 000004EXCLUDE 1341
OMAK 000004EXCLUDE 1341
OMAK 000005EXCLUDE 1341
OMAK 000005EXCLUDE 1341
OMAK 000005EXCLUDE 1341

I want the output as

OMAK EXCLUDE 000002 3 1341
OMAK EXCLUDE 000003 3 1341
OMAK EXCLUDE 000004 4 1341
OMAK EXCLUDE 000005 3 1341

I have this program
which is doing quite well. Except for the last line where i could not get any output. There is something to do with END of awk.

awk '{ curr=substr($0,1,11)

if ( curr != prev && prev != "")
{
a=sprintf("%s %-50s %6s %-6s %s",substr(prev_0,1,5),substr(prev_0,12,29),substr(prev_0,6,6),count,substr(prev_0,41,4))
print a
count=0
}
count++
prev=curr
prev_0=$0
} END {a=sprintf("%s %-50s %6s %-6s %s",substr($0,1,5),substr($0,12,29),substr($0,6,6),count,substr($0,41,4))
print a
}' OMAK_11

Can any one tell me how to fix this?

Regards
Dhana

dhanamurthy

View Public Profile for dhanamurthy

Find all posts by dhanamurthy

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Counting The Number Of Duplicate Lines In a File

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. Linux

counting the number of lines

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...

3. Shell Programming and Scripting

counting the number of lines - again

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,

4. Shell Programming and Scripting

counting non integer number in awk

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,...

5. Shell Programming and Scripting

Counting similar lines from file UNIX

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. Shell Programming and Scripting

awk counting number of occurences

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...

7. Shell Programming and Scripting

Counting similar lines

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...

8. Shell Programming and Scripting

Running sed and counting number of lines processed

/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...

9. Shell Programming and Scripting

Counting lines in a file using awk

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.

10. Shell Programming and Scripting

[Solved] Counting The Number of Lines Between Values with Multiple Variables

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,...

LEARN ABOUT CENTOS

tapset::string

tapset::string(3stap)													     tapset::string(3stap)

NAME

       tapset::string - systemtap string tapset

DESCRIPTION

       strlen Returns the length of a string

	      See function::strlen(3stap)
	       for details.

       substr Returns a substring

	      See function::substr(3stap)
	       for details.

       stringat
	      Returns the char at a given position in the string

	      See function::stringat(3stap)
	       for details.

       isinstr
	      Returns whether a string is a substring of another string

	      See function::isinstr(3stap)
	       for details.

       text_str
	      Escape any non-printable chars in a string

	      See function::text_str(3stap)
	       for details.

       text_strn
	      Escape any non-printable chars in a string

	      See function::text_strn(3stap)
	       for details.

       - strtol
	      Convert a string to a long

	      See function::-strtol(3stap)
	       for details.

       isdigit
	      Checks for a digit

	      See function::isdigit(3stap)
	       for details.

SEE ALSO

	 function::strlen(3stap),    function::substr(3stap),	function::stringat(3stap),  function::isinstr(3stap),  function::text_str(3stap),
       function::text_strn(3stap),  function::-(3stap),  function::strtol(3stap),  function::isdigit(3stap),  stap(1), stapprobes(3stap)

IBM
									---						     tapset::string(3stap)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Counting The Number Of Duplicate Lines In a File

Discussion started by: crunchtime

2. Linux

counting the number of lines

Discussion started by: nayeemmz

3. Shell Programming and Scripting

counting the number of lines - again

Discussion started by: f_o_555

4. Shell Programming and Scripting

counting non integer number in awk

Discussion started by: chaitubek