Filtering Data - Shell Programming and Scripting

Raynon · #1 (**permalink**) 08-22-2007

Hi All,

I have the below input and expected ouput. I need a code which can scan through this input file and if the number in column1 is more than 1 , it will print out the whole line, else it will output "No Re-occurrence". Can anybody help ?

Input:

1 vvvvv 20 7 7 23 0 64
6 zzzzzz 11 5 5 13 0 1
1 uuuuu 17 0 0 24 0 146
5 qqqqq 7 3 3 11 0 199
1 ggggg 11 5 5 13 0 13
1 yyyyy 13 7 7 31 0 252

Expected Output:

6 zzzzzz 11 5 5 13 0 1
5 qqqqq 7 3 3 11 0 199

Ygor · #2 (**permalink**) 08-22-2007

Try...

Code:

awk '{if ($1>1) print $0; else print "No Re-occurrence"}' file1

ghostdog74 · #3 (**permalink**) 08-22-2007

Code:

awk '$1>1?1:$0="No occurence"' file

output:

Code:

# ./test.sh
No occurence
6 zzzzzz 11 5 5 13 0 1
No occurence
5 qqqqq 7 3 3 11 0 199
No occurence
No occurence

by the way, try to put in some effort next time.

Raynon · #4 (**permalink**) 08-22-2007

Hi Ghostdog,

I only want the the below to surface column1 more than 1.

6 zzzzzz 11 5 5 13 0 1
5 qqqqq 7 3 3 11 0 199

If column1 does not contain 1 then output "No occurence"

eg
Input:
1 vvvvv 20 7 7 23 0 64
1 uuuuu 17 0 0 24 0 146
1 ggggg 11 5 5 13 0 13
1 yyyyy 13 7 7 31 0 252

Output:
No occurrence

namishtiwari · #5 (**permalink**) 08-22-2007

If you do not want the lines with first column =1 then just remove the else part of the syntaxes recomended above.

Thanks
namish

aigles · #6 (**permalink**) 08-23-2007

Try this :

Code:

awk '$1>1 { print; c++ } END { if (c==0) print "No occurrence" }' file

Jean-Pierre.

Raynon · #7 (**permalink**) 09-04-2007

Thnks Jean it works!!

However, how can i modify the code such that when 2 or more terms are repeated consecutively, it will output the the repeating term, else echo "No consecutive repeating term ?

Input:
vvvvv 20 7 7 23 0 64
uuuuu 17 0 0 24 0 146
uuuuu 17 0 0 24 0 146
uuuuu 17 0 0 24 0 146
ggggg 11 5 5 13 0 13
yyyyy 13 7 7 31 0 252
ggggg 11 5 5 13 0 13

Expected Output:
Consecutive Repeating term = uuuuu 17 0 0 24 0 146

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
filtering the logs	prvnrk	Shell Programming and Scripting	5	04-08-2008 06:57 PM
awk and sed filtering	invinzin21	Shell Programming and Scripting	2	01-10-2008 11:56 PM
Filtering Data	bobo	UNIX for Dummies Questions & Answers	2	09-19-2007 12:06 PM
awk filtering ?	varungupta	UNIX for Advanced & Expert Users	4	09-16-2007 11:55 PM
Filtering out data ...	videsh77	UNIX for Dummies Questions & Answers	1	12-29-2004 12:59 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode