08-09-2012 06:01 AM - edited 03-07-2019 08:15 AM
Our cabling contractor gives us a spreadsheet of room# and patch panel# in spreadsheet format. Working for a University we are always having new buildings pop up with many ports. In this case, we have 25 buildings with 1, 48 port switch in each. I received the spreadsheet and am looking for a way to grab the info off the spreadsheet to be able to turn into an automated script or something that will create a way to speed up the process of naming all these ports.
The ideal thing I would like to do is have something just do
int fa0/1
desc xxxxxx
int fa0/2
desc xxxxx
and so on.
Does anyone have any special tools/tricks they use when it comes to multiple port naming.
This is how the spreadsheet looks...
House# 121 | |
Room# | Port# |
101 | 8 |
101 | 7 |
104 | 16 |
106 | 10 |
103 | 11 |
08-09-2012 09:51 AM
In the past I have used the concatenate function in Excel.I always use the inset fuction to help create the statement.
11-29-2023 06:42 AM
Hi Nicholas,
I was just wondering if you did find a solution for this?
Kind regards,
Kat
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide