[NTLUG:Discuss] Is there an easy way?
Chris Cox
cjcox at acm.org
Sun Jul 26 12:42:08 CDT 2009
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.
More information about the Discuss
mailing list