From owner-freebsd-questions  Thu Feb  8  4:47: 9 2001
Delivered-To: freebsd-questions@freebsd.org
Received: from www.ansp.br (www.fapesp.br [143.108.25.7])
	by hub.freebsd.org (Postfix) with ESMTP id CD5E737B4EC
	for <freebsd-questions@freebsd.org>; Thu,  8 Feb 2001 04:46:50 -0800 (PST)
Received: from ansp.br (performance.ansp.br [143.108.22.7])
	by www.ansp.br (Postfix) with ESMTP
	id 26A0610C099; Thu,  8 Feb 2001 10:44:02 -0200 (BRST)
Message-ID: <3A829537.4FE4F7C4@ansp.br>
Date: Thu, 08 Feb 2001 10:46:47 -0200
From: Marcus Ramos <marcus@ansp.br>
Organization: Fapesp
X-Mailer: Mozilla 4.73 [en] (X11; I; FreeBSD 4.1-RELEASE i386)
X-Accept-Language: en
MIME-Version: 1.0
To: "Zaitsau, Andrei" <AZaitsau@panasonicfa.com>,
	"'freebsd-questions@freebsd.org'" <freebsd-questions@freebsd.org>
Subject: Re: sed & awk help...?!
References: <054F7DAA9E54D311AD090008C74CE9BD01F1E94E@exchange.panasonicfa.com> <3A819412.BF10DCB2@ansp.br>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

Hi,

Here's what you need:

awk 'match ($2, $1) {print $1, $3}' input-file

Hope you can sleep now.
Regards,
Marcus.

Marcus Ramos wrote:

> Seems rather simple, but I don't have my AWK book with me right now. I'll take
> a look tonight and give feedback tomorrow.
> Marcus.
>
> "Zaitsau, Andrei" wrote:
>
> > 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
>
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-questions" in the body of the message



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