awk check for equal - help

uwork72 · #1 (**permalink**) 02-24-2009

Input file:

Code:

x A 10
y A 10
z A 10
x B 10
y B 12
z B 10
x C 0
y C 0

vgersh99 · #2 (**permalink**) 02-24-2009

Quote:

Originally Posted by uwork72

Input file:

Code:

x A 10
y A 10
z A 10
x B 10
y B 12
z B 10
x C 0
y C 0

Required output:

Code:

x B 10
y B 12
z B 10

i.e. printing only that section (based on 2nd field) for which third field($3) is not equal for all the lines for that 2nd field. Please help

Hmm..... this is a bit confusing...
why do you have records in red then?

Code:

x B 10
y B 12
z B 10

zaxxon · #3 (**permalink**) 02-24-2009

It's easy to produce the desired ouput but I didn't understand your explanaton.

Quote:

for which third field($3) is not equal for all the lines for that 2nd field

So you want those having $2 == B and also the whole line being unique?

If so...

Code:

grep " B " infile| uniq

uwork72 · #4 (**permalink**) 02-24-2009

Thanks Zaxxon and vgersh99 for the reply.

I want to only print the section for which 3rd field is different (one section is basically based on second field, here A,B and C ).

Code:

x A 10
y A 10
z A 10
x B 10
y B 12
z B 10
x C 0
y C 0

salil2012 · #5 (**permalink**) 02-24-2009

To: UnWork72
The replies you have been recived are really for that you have actually asked???

coz i feel you are not specific about "B" in column 2, i mean $2

What i feel is it depends on column 2 but you have to find unmatched in column 3,
m i rite???

if yes.... can we work out n discuss

vgersh99 · #6 (**permalink**) 02-24-2009

Quote:

Originally Posted by uwork72

Thanks Zaxxon and vgersh99 for the reply.

I want to only print the section for which 3rd field is different (one section is basically based on second field, here A,B and C ).

Code:

x A 10
y A 10
z A 10
x B 10
y B 12
z B 10
x C 0
y C 0

ok, so what the output of the above?

uwork72 · #7 (**permalink**) 02-24-2009

Quote:

Originally Posted by vgersh99

ok, so what the output of the above?

Code:

x B 10
y B 12
z B 10

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
while loop not taking the not equal to condition	ssuresh1999	UNIX for Dummies Questions & Answers	9	08-12-2008 10:05 AM
Edit entry if not equal	kenshinhimura	Shell Programming and Scripting	4	08-07-2008 12:18 AM
Stop+A equal	tlee	Solaris	5	07-01-2008 07:42 AM
add not equal in script.	myguess21	Shell Programming and Scripting	2	02-26-2008 10:20 AM
Making a variable equal a pattern	Bab00shka	UNIX for Dummies Questions & Answers	3	03-08-2004 06:46 AM