[NTLUG:Discuss] Is there an easy way?

[Leroy Tennison]

Michael Barnes wrote:
> On Sun, Jul 26, 2009 at 12:42 PM, Chris Cox <cjcox at acm.org> wrote:
> 
>> On Sun, 2009-07-26 at 00:06 -0500, Leroy Tennison wrote:
>>> I'm not even sure how to Google for this one without having to wade
>>> through too many extraneous hits so I'm posting here.  I have three
>>> files and need to merge fields from each of them into a single file.  A
>>> brief description of each is:
>>>
>>> File 1 has a phone number and an associated IP address (VOIP, Avaya PBX)
>>> File 2 has an IP address and an associated MAC address (Cisco router).
>>> File 3 has a MAC address and associated Cisco switch port assignment.
>>>
>>> I need a file containing phone number and associated switch port.
>> man join
>>
>> You'll need to sort by the key field before joining files.
>>
>> It's like a two table join in sql.
>>
> 
> Ah, the joy of Linux.  Ask three guys how to do something and get five
> solutions, each of which is valid and will work, yet each totally different.
> 
> I love it.
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss
> 
Far better than the alternative: "Do it our one way.  And, oh BTW, 
that'll be $$$".