Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sum using awk with pattern match
Top Forums Shell Programming and Scripting sum using awk with pattern match Post 302694465 by sol_nov on Thursday 30th of August 2012 06:09:15 PM
Old 08-30-2012
CPU & Memory sum using awk with pattern match
I have a file which has data like this
Code:
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Insert completed. 5 rows added.
 *** Query completed. No rows found.
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. No rows found.
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. No rows found.
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Insert completed. 10 rows added.
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. No rows found.
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. No rows found.
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. No rows found.
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. One row found. 
 *** Query completed. No rows found.
 *** Query completed. One row found.

I want to sum all the rows found i.e. The total sum should be 47.

For now I am using

Code:
 awk '/\*\*\* Insert completed. | \*\*\* Query completed./ { SUM += $4 } END { printf ("Rows inserted: %d \n", SUM) }' file

But with this, it is skipping the 'One'. I am trying to equate One to 1. Please let me know how we can do this?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how do i pattern match a field with awk?

hi, let's say $numbers = "324 350 587" an so on... what i'm trying to do is this: awk -v numbers="$numbers" '{if (numbers ~ /$2/) print $0, "bla bla"}' file # file looks like this: 214 ..... 215 ... 216 .... 250 ... 324 325 ... 350 something ... ... 587 ... (4 Replies)
Discussion started by: someone123
4 Replies

2. Shell Programming and Scripting

want to pattern match using awk

Hello Friends, My script gives an output like below:- but i only want the red part to be displayed. how to i do that. I am enclosing my shell script after that. id='CCRCWebServerINSTALLDIR' id='AdministrationTools-CINSTALLDIR' id='AdministrationTools-ent-CINSTALLDIR'... (3 Replies)
Discussion started by: asirohi
3 Replies

3. Shell Programming and Scripting

Use to awk to match pattern, and print the pattern

Hi, I know how to use awk to search some expressions like five consecutive numbers, , this is easy. However, how do I make awk print the pattern that is been matched? For example: input: usa,canada99292,japan222,france59664,egypt223 output:99292,59664 (6 Replies)
Discussion started by: grossgermany
6 Replies

4. Shell Programming and Scripting

awk to sum specific field when pattern matches

Trying to sum field #6 when field #2 matches string as follows: Input data: 2010-09-18-20.24.44.206117 UOWEXEC db2bp DB2XYZ hostname 1 2010-09-18-20.24.44.206117 UOWWAIT db2bp DB2XYZ hostname ... (3 Replies)
Discussion started by: ux4me
3 Replies

5. Shell Programming and Scripting

pattern match .com in awk script

guys ! I want to search .com,.html files ..... how do I match pattern...? here's wht I hv written if ( $i ~ /.com/ ) even escaping it doesn't help if ( $i ~ /\.com/ ) (2 Replies)
Discussion started by: shreeprabha
2 Replies

6. Shell Programming and Scripting

AWK match $1 $2 pattern in file 1 to $1 $2 pattern in file2

Hi, I have 2 files that I have modified to basically match each other, however I want to determine what (if any) line in file 1 does not exist in file 2. I need to match column $1 and $2 as a single string in file1 to $1 and $2 in file2 as these two columns create a match. I'm stuck in an AWK... (9 Replies)
Discussion started by: right_coaster
9 Replies

7. Shell Programming and Scripting

Awk to match a pattern and perform a search after the first pattern

Hello Guyz I have been following this forum for a while and the solutions provided are super useful. I currently have a scenario where i need to search for a pattern and start searching by keeping the first pattern as a baseline ABC DEF LMN EFG HIJ LMN OPQ In the above text i need to... (8 Replies)
Discussion started by: RickCharles
8 Replies

8. Shell Programming and Scripting

Why sum of recs in awk don't match total rec count?

I'm using awk to determine if a field starting in position 604 for length of 10 is not equal to ALL spaces. It's searching several files which are in the current directory. The below awk indicates that there are 84 records on all files where this field IS NOT equal to ALL spaces ( there are 10... (2 Replies)
Discussion started by: mjf
2 Replies

9. Shell Programming and Scripting

Pattern match with awk/sed - help

I need to grep for the pattern text inside the square brackets which are in red and not in green..my current code greps patterns both of them, which i don't want Input fileref|XP_002371341.1| oxoacyl-ACP reductase, putative gb|EPT24759.1| 3-ketoacyl-(acyl-carrier-protein) reductase ... (2 Replies)
Discussion started by: selvankj
2 Replies

10. Shell Programming and Scripting

awk to combine lines from line with pattern match to a line that ends in a pattern

I am trying to combine lines with these conditions: 1. First line starts with text of "libname VALUE db2 datasrc" where VALUE can be any text. 2. If condition1 is met then continue to combine lines through a line that ends with a semicolon. 3. Ignore case when matching patterns and remove any... (5 Replies)
Discussion started by: Wes Kem
5 Replies

LEARN ABOUT DEBIAN

cgi::application::plugin::devpopup::query

Query(3pm)						User Contributed Perl Documentation						Query(3pm)

NAME

       CGI::Application::Plugin::DevPopup::Query - show CGI query in DevPopup window

SYNOPSIS

	   use CGI::Application::Plugin::DevPopup;
	   use CGI::Application::Plugin::DevPopup::Query;

	   The rest of your application follows
	   ...

DESCRIPTION

       This module is a plugin for CGI::Application::Plugin::DevPopup.	Whenever used, it creates two sections in the DevPopup output.	First
       section, "Current Run Mode", shows name of run mode executed.  Second section, "CGI Query", contains a list of CGI query parameters and
       associated values passed to your CGI::Application.

       See "query()" in CGI::Application and CGI.pm for more information about query parameters.

VERSION

       1.03

SUBROUTINES
/METHODS
       No public methods for this module exist.

DEPENDENCIES

       CGI::Application::Plugin::DevPopup

CONFIGURATION AND ENVIRONMENT

       N/A

DIAGNOSTICS

       N/A

SEE ALSO

       CGI::Application::Plugin::DevPopup, CGI::Application

INCOMPATIBILITIES

       Not known.

BUGS AND LIMITATIONS

       Not known.

AUTHOR

       Serguei Trouchelle, <mailto:stro@cpan.org>

       Most of code is based by CGI::Application::Plugin::DevPopup by Rhesa Rozendaal, <mailto:rhesa@cpan.org>

LICENSE AND COPYRIGHT

       This module is distributed under the same terms as Perl itself.

       Copyright (c) 2009-2011 Serguei Trouchelle

perl v5.12.4							    2011-11-01								Query(3pm)
All times are GMT -4. The time now is 03:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy