From owner-freebsd-questions  Wed Feb  7 18: 4:43 2001
Delivered-To: freebsd-questions@freebsd.org
Received: from guru.mired.org (okc-65-26-235-186.mmcable.com [65.26.235.186])
	by hub.freebsd.org (Postfix) with SMTP id D2BDA37B4EC
	for <questions@freebsd.org>; Wed,  7 Feb 2001 18:04:25 -0800 (PST)
Received: (qmail 37370 invoked by uid 100); 8 Feb 2001 02:04:20 -0000
From: Mike Meyer <mwm@mired.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <14977.65188.714090.78124@guru.mired.org>
Date: Wed, 7 Feb 2001 20:04:20 -0600 (CST)
To: "Zaitsau, Andrei" <AZaitsau@panasonicfa.com>
Cc: questions@freebsd.org
Subject: Re: sed & awk help...?!
In-Reply-To: <24449540@toto.iv>
X-Mailer: VM 6.75 under 21.1 (patch 10) "Capitol Reef" XEmacs Lucid
X-face: "5Mnwy%?j>IIV\)A=):rjWL~NB2aH[}Yq8Z=u~vJ`"(,&SiLvbbz2W`;h9L,Yg`+vb1>RG%
 *h+%X^n0EZd>TM8_IB;a8F?(Fb"lw'IgCoyM.[Lg#r\
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

Well, on first reading, I thought you just wanted this:

	awk '$1 == $2 { print $1, $3 } ' <infile >outfile

However, on the second reading, I'm not sure that's what your asking
for. Could you provide the correct output for the sample input you've
got?

	<mike

Zaitsau, Andrei <AZaitsau@panasonicfa.com> types:
> Hello Everyone,
> I have small work related problem.
> Can someone help me with that? It's more UNIX question.
> 
> Please CC me as I am not subscribed to a list.
> 
> Here The Problem.
> I have a file. And there is 3 tables in it.
> 
> 1	12	ac
> 3	4	ab
> 5	6	ac
> 7	8	ac
> 9	1	ab
> 2	13	ab
> 4	5	ac
> 6	7	ab
> 8	9	ab
> 
> The thing I need is to do some sorting.
> I guess it could be done with 'awk' or 'sed' utilities.
> 
> Okay program looking at the first value of the first table and compare it to
> the value in the second table. If it finds a match on the second table it
> outputs to other file matching value plus corresponding value from the 3rd
> table (just look at it as 2nd and 3rd tables are hard linked).
> 
> example: program is looking at value '1' in the 1st table, finds exact value
> in the second table and outputs this value and corresponding letters 'ab' to
> a separate file (other way to see it 2nd and 3rd table are hard linked)
> second step it checks value '3' from the first table and it does not find it
> in 2nd table, so it skips the record. And does not output anything
> Next, 5 in first table matches 5 in 2nd table so it outputs '5 ac' in the
> file (2nd and 3rd tables are hardlinked)
> 
> I am not sure if I explaining it clearly enough, but I hope someone got the
> idea.
> Please help me how to do it, I loose my sleep for 3 days already...
> Thanks.
> 
> 
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-questions" in the body of the message
> 
--
Mike Meyer <mwm@mired.org>			http://www.mired.org/home/mwm/
Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information.


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message