[NTLUG:Discuss] Is there an easy way?

Leroy Tennison leroy_tennison at prodigy.net
Sun Jul 26 00:06:14 CDT 2009


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.

This may be somewhat OT except I'm hoping there's a Linux utility which 
will meet the need.  I know that I can turn each file into a database 
table and do some operation on two tables to "merge" their fields and 
then repeat again to get what I need but that's the extent of my 
understanding of that option.  Wondering if there's a utility to take 
the files directly and do the "merge".  This is a situation where 
scripting seems to be the wrong solution, I've written something similar 
in awk and don't want to do that again.  I'm also not looking forward to 
writing a program in a "real programming language" to accomplish this 
either.  Thanks for any input.



More information about the Discuss mailing list