Date: Wed, 7 Feb 2001 20:04:20 -0600 (CST) From: Mike Meyer <mwm@mired.org> To: "Zaitsau, Andrei" <AZaitsau@panasonicfa.com> Cc: questions@freebsd.org Subject: Re: sed & awk help...?! Message-ID: <14977.65188.714090.78124@guru.mired.org> In-Reply-To: <24449540@toto.iv>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?14977.65188.714090.78124>