Count lines with awk if statements Post: 302987465

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk help needed in trying to count lines,words and characters

Hello, i am trying to write a script file in awk which yields me the number of lines,characters and words, i checked it many many times but i am not able to find any mistake in it. Please tell me where i went wrong. BEGIN{ print "Filename Lines Words Chars\n" } { filename=filename + 1...

2. Shell Programming and Scripting

awk: sort lines by count of a character or string in a line

I want to sort lines by how many times a string occurs in each line (the most times first). I know how to do this in two passes (add a count field in the first pass then sort on it in the second pass). However, can it be done more optimally with a single AWK command? My AWK has improved...

3. Shell Programming and Scripting

How to execute a no of SELECT COUNT(*) statements using a loop

HI Unix Gurus, I have a number of SELECT count(*) statements in an input file and I want to execute it using a shell script but one by one using loop in script.... How can I do this.....

4. Shell Programming and Scripting

awk to count duplicated lines

We have an input file as follows: 2010-09-15-12.41.15 2010-09-15-12.41.15 2010-09-15-12.41.24 2010-09-15-12.41.24 2010-09-15-12.41.24 2010-09-15-12.41.24 2010-09-15-12.41.25 2010-09-15-12.41.26 2010-09-15-12.41.26 2010-09-15-12.41.26 2010-09-15-12.41.26 2010-09-15-12.41.26...

5. Shell Programming and Scripting

Count lines AWK

Hi, how can I count the lines where a word appears in a file, using AWK? Example: file.txt: gold 1588 France gold 1478 Spain silver 1596 France emerald 1584 UK diamond 1478 Germany gold 1639 USA Number of lines where gold in text is = 3 I've try this, but all I get is the number...

6. Shell Programming and Scripting

Multiple pattern matching using awk and getting count of lines

Hi , I have a file which has multiple rows of data, i want to match the pattern for two columns and if both conditions satisfied i have to add the counter by 1 and finally print the count value. How to proceed... I tried in this way... awk -F, 'BEGIN {cnt = 0} {if $6 == "VLY278" &&...

7. Shell Programming and Scripting

Combine 4 awk pattern count statements into 1

Hello fellow awkers, I am trying to combine the following awk statements into 1 so that the results are more accurate: awk '/\=\+/ { count++ } END { print count}' filename awk '/\=\?/ { count++ } END { print count}' filename awk '/\=\-/ { count++ } END { print count}' filename awk...

8. Shell Programming and Scripting

Count words/lines between two tags using awk

Is there an efficient awk that can count the number of lines that occur in between two tags. For instance, consider the following text: <s> Hi PP - my VBD - name DT - is NN - . SENT . </s> <s> Her PP - name VBD - is DT - the NN - same WRT - . SENT - </s> I am interested to know...

9. Shell Programming and Scripting

awk to print before and after lines then count of patterns

What i'm trying to do here is show X amount of lines before and after the string "serialNumber" is found. BEFORE=3 AFTER=2 gawk '{a=$0} {count=0} /serialNumber/ && /./ {for(i=NR-'"${BEFORE}"';i<=NR;i++){count++ ;print a}for(i=1;i<'"${AFTER}"';i++){getline; print ; count ++; print...

10. Shell Programming and Scripting

awk to remove lines where field count is greather than 1 in two fields

I am trying to remove all the lines and spaces where the count in $4 or $5 is greater than 1 (more than 1 letter). The file and the output are tab-delimited. Thank you :). file X 5811530 . G C NLGN4X 17 10544696 . GA G MYH3 9 96439004 . C ...

LEARN ABOUT DEBIAN

wiki-toolkit-revert-to-date

WIKI-TOOLKIT-REVERT-TO-DATE(1p) 			User Contributed Perl Documentation			   WIKI-TOOLKIT-REVERT-TO-DATE(1p)

NAME

       wiki-toolkit-revert-to-date - Revert the state of a Wiki::Toolkit instance to an earlier point in time.

SYNOPSIS

	 # Removes any changes made to a Wiki::Toolkit instance since a given date
	 #  (and optionally time), restoring it to the state at that point.

	 wiki-toolkit-revert-to-date --type postgres
		  --name mywiki 
		  --user wiki  
		  --pass wiki 
		  --host 'db.example.com' 
		  --port 1234 
		  --date 2007-01-05 
		  --time 11:23:21

DESCRIPTION

       Takes three mandatory arguments:

       type
	   The database type.  Should be one of 'postgres', 'mysql' and 'sqlite'.

       name
	   The database name.

       date
	   The date to revert the state back to, in the format YYYY-MM-DD

       five optional arguments:

       time
	   The time (on the specified date) to revert the state back to, in the format hh:mm:ss. If not specified, will use midnight.

       user
	   The user that connects to the database. It must have permission to create and drop tables in the database.

       pass
	   The user's database password.

       host
	   The hostname of the machine the database server is running on (omit for local databases).

       port
	   The port number that the database server is expecting connections to.

AUTHOR

       Nick Burch

COPYRIGHT

	    Copyright (C) 2006 Nick Burch.  All Rights Reserved.

       This code is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Wiki::Toolkit

perl v5.14.2							    2011-09-25					   WIKI-TOOLKIT-REVERT-TO-DATE(1p)