Date: Thu, 08 Feb 2001 10:46:47 -0200 From: Marcus Ramos <marcus@ansp.br> To: "Zaitsau, Andrei" <AZaitsau@panasonicfa.com>, "'freebsd-questions@freebsd.org'" <freebsd-questions@freebsd.org> Subject: Re: sed & awk help...?! Message-ID: <3A829537.4FE4F7C4@ansp.br> References: <054F7DAA9E54D311AD090008C74CE9BD01F1E94E@exchange.panasonicfa.com> <3A819412.BF10DCB2@ansp.br>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3A829537.4FE4F7C4>