From owner-freebsd-questions Wed Feb 7 10:29:58 2001 Delivered-To: freebsd-questions@freebsd.org Received: from www.ansp.br (www.ansp.br [143.108.25.7]) by hub.freebsd.org (Postfix) with ESMTP id 5015637B503 for ; Wed, 7 Feb 2001 10:29:39 -0800 (PST) Received: from ansp.br (performance.ansp.br [143.108.22.7]) by www.ansp.br (Postfix) with ESMTP id 2071010C08C; Wed, 7 Feb 2001 16:26:56 -0200 (BRST) Message-ID: <3A819412.BF10DCB2@ansp.br> Date: Wed, 07 Feb 2001 16:29:38 -0200 From: Marcus Ramos 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" Cc: "'freebsd-questions@freebsd.org'" Subject: Re: sed & awk help...?! References: <054F7DAA9E54D311AD090008C74CE9BD01F1E94E@exchange.panasonicfa.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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