|
|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| It's time to learn Scheme | iBot | UNIX and Linux RSS News | 0 | 04-03-2008 01:40 AM |
| Loops within loops | bthomas | Shell Programming and Scripting | 8 | 04-14-2005 10:09 AM |
| korn shell "loops & arrays" | muzica | Shell Programming and Scripting | 7 | 09-23-2004 12:02 PM |
| should i take the time to learn? | hiei | UNIX for Dummies Questions & Answers | 1 | 03-30-2004 03:11 PM |
| While loops | bookoo | UNIX for Dummies Questions & Answers | 5 | 08-23-2002 08:01 AM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
05-14-2008
|
|||
|
|||
|
trying to learn for loops, and arrays at the same time
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: Code:
#!/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
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: Code:
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
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) 
|
| Forum Sponsor | ||
|
|
|
05-14-2008
|
||||
|
||||
|
awk
If I correctly understand your requirement:
HDBOXREPORT Code:
1033 1 1079 4 1453 5 2205 6 1933 7 461 8 646 9 1655 12 975 13 1289 14 Code:
+-----------------------------------------+ +-------------------------+ | 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 Code:
awk 'NR==FNR{a[$2]=$2;next}
$7 in a {print $7, $8}' HDBOXREPORT QSPK-list
Output: Code:
1 SMANHUBBQPSKE02 4 SMANHUBDQPSKE01 5 SMANHUBDQPSKE02 6 SMANHUBCQPSKE03 7 SMANHUBCQPSKE04
|
|
05-14-2008
|
|||
|
|||
|
Thank you so much for your reply, honestly I don't understand it...my awk skills (like all of my skills) are pretty basic. I actually wound up constructing something that does my job for me...in the end it turns out I wasn't matching strictly enough. greping for "^$x" was returning more than just the one result I wanted.
In case anyone cares here is what I eventually used to do the job: Code:
#!/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
cat qpsklist|nawk -v x=$x '{if (x == $7) print $8}'
done
|
|
05-14-2008
|
||||
|
||||
|
Quote:
Section related to file HDBOXREPORT. Code:
NR==FNR --> While the condition NR==FNR is true,
NR --> Record Number which counts all the lines in both files,
FNR --> Filename Record Number, which counts the lines in only one file, then restarts numbering when the lines of the second file are being processed, then continue with the other statement:
{a[$2]=$2;next} --> build the array a with all the elements from field 2 of the first file HDBOXREPORT while NR==FNR is true,
next --> read all the elements from that file, without continuing any further in the script.
Code:
$7 in a --> Special test operator of assocciative arrays that checks if elements of field 7 ($7) from file QSPK-list are part of the array a created from file QSPK-list. When this condition is true then:
{print $7, $8} --> simply print the required fields from file QSPK-list.
|
||||
| Google The UNIX and Linux Forums |
Linear Mode
