Ok, I've already completed the task this is for, but now I'm trying to go back and find more eloquent solutions for future reference. I have a report I've generated that is formatted like this:
1033 1
1079 4
1453 5
2205 6
1933 7
461 8
646 9
1655 12
975 13
1289 14
The first number is the number of Cable boxes, the second number is the ID of the modulator that they are hooked up to (I'm sure noone cares, but I like adding back story...). What I want to do is using the second number (the ID) lookup the name of that modulator from a file formated like this:
+-----------------------------------------+ +-------------------------+
| QPSK Name Broadcast_Addr ID | | ID QPSK Name |
+-------------------- --------------- --- + + --- --------------------+
| BERGENQPSK1 10.180.127.255 90 | | 1 SMANHUBBQPSKE02 |
| BERGENQPSK1B 10.182.127.255 238 | | 2 SMANHUBBQPSKE03 |
| BERGENQPSK2 10.180.191.255 109 | | 3 SMANHUBBQPSKE04 |
| BERGENQPSK2B 10.182.191.255 239 | | 4 SMANHUBDQPSKE01 |
| BERGENQPSK3 10.180.255.255 158 | | 5 SMANHUBDQPSKE02 |
| BERGENQPSK3B 10.182.255.255 240 | | 6 SMANHUBCQPSKE03 |
| BERGENQPSK4 10.181.127.255 93 | | 7 SMANHUBCQPSKE04
column 7 being the same ID number referenced in the first file, and column 8 being the name I'm trying to get. At this point all I want is to get a list of just the names in the same order that they are on the report so that I can paste it into an excel spreadsheet and it'll line up.
What I've got so far is:
#!/usr/bin/bash
#create an array with just the mod ID's
a=(`cat HDBOXREPORT |awk '{print $2}'`)
#for each element of the array, look through the MOD list and and print just the name column
for x in "${a[@]}"
do
listQpsk 999|awk '{print $7,$8}'|grep ^$x
done
which returns :
1 SMANHUBBQPSKE02
10 SMANHUBAQPSKE5
11 SMANHUBAQPSKE6
12 SMANHUBAQPSKE7
13 SMANHUBAQPSKE8
14 NMANHUBGQPSKE03
15 NMANHUBGQPSKE04
16 NMANHUBFQPSKE02
17 NMANHUBFQPSKE04
109 BERGENQPSK2
---etc---
ID's and names, but not in the order of the original file (the HDBOXREPORT) and it has 251 lines of output which I don't understand as the HDBOXREPORT has only 143 lines, and the QPSK list only has 152 lines.
I thought possibly the elements of my array were wrong so I tried running:
a=( 1 2 3 4 5 6 7 8 9 )
#for each element of the array, look through the MOD list and and print just the name column
for x in "${a[@]}"
do
listQpsk 999|awk '{print $7,$8}'|grep ^$x
done
but this again gave me a list with MOD ID's and names, but not in order, and this time with 147 lines of output.
Like I said, this is my first attempt at setting an array or at using a for loop so I don't really know where to proceed from here. Any advice I'd appreciate.
Oh and as a side not, I'm sure there are all kinds of awesome ways to get the results I want, but I'm trying to build up my fundamental skills at the moment, so if you could point me in the right direction using the path I've already started on, rather than a totally different method that would yield the results I'm looking for I'd appreciate it (not that I wouldn't love to see alternate methods)