Sponsored Content
Full Discussion: arrays how to?
Top Forums UNIX for Dummies Questions & Answers arrays how to? Post 302311202 by vlopez on Tuesday 28th of April 2009 06:56:53 AM
Old 04-28-2009
arrays how to?

Hello,

I am some what of a newbie to awk scripting and I seem to be struggling with this problem.
I know I need to use arrays but I can't figure out how to use them.



I have an input file that looks like this;

Name,Team,First Test, Second Test, Third Test
Crystal,Red,5,17,22
Vince,Green,3,14,22
Yolanda,Blue,6,18,21
Alfredo,Blue,2,15,23
Charlie,Red,-1,15,24
Phillop,Green,7,19,21
Edword,Green,3,16,20
Irene,Red,9,12,24


I need the output to look like this;
if the score is a '-1' that means the person
was absent that day and did not take the test
and the '-1' must not be included in the average.

Name Average
---- -------
Crystal 14.67
Vince 13.00
Yolanda 15.00
Alfredo 13.33
Charlie 19.50
Phillop 15.67
Edward 13.00
Irene 15.00
------------------
Average for Test 1 : 5
Average for Test 2 : 15.75
Average for Test 3 : 22.125
-------------------
Average for Red Team: 16
Average for Green Team: 13.8889
Average for Blue Team: 14.1667


This out put data will be used in a middle school trial run academics incentive program based on academics and their role as a team player.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Arrays

Dear all, How can i unset arrays. I mean all the subscripts including the array after using them. Could you direct me to some links of array memory handling in the korn shell. Thanks (2 Replies)
Discussion started by: earlysame55
2 Replies

2. Web Development

PHP arrays in arrays

PHP question... I have an SQL query that's pulled back user IDs as a set of columns. Rather than IDs, I want to use their names. So I have an array of columns $col with values 1,7,3,12 etc and I've got an array $person with values "Fred", "Bert", "Tom" etc So what I want to do is display the... (3 Replies)
Discussion started by: JerryHone
3 Replies

3. HP-UX

Hitachi arrays to HP-UX 11.11

We have 2 servers (L1000 and rp7410) running 11.11. We would like to hook them up to either a Hitatchi AMS 2500 or Hitachi USPV via fiber channel. I need to what drivers I need for this and if it will work. Oh, they are using HP Tachyon XL2 Fiber Channel Mass Storage Adapters. Thanks, Bill (1 Reply)
Discussion started by: wsmcelroy
1 Replies

4. Shell Programming and Scripting

2d arrays in unix

hi everybody can anyone help me with usage of 2 dimensional arrays in unix. please provide a suitable example for accessing individual elements as well as all elements. Thanks (2 Replies)
Discussion started by: jpriyank
2 Replies

5. Shell Programming and Scripting

Using arrays in shell

I have three arrays. One is Master array and that has list of other array in config file. for e.g (for simplicity I have only defined array with 2 elements each) set +A MASTERARRAY SQLUPDATE_ONETIME SQLUPDATE_DAILY END_OF_ARRAY set +A SQLUPDATE_ONETIME update12 update22 END_OF_ARRAY... (4 Replies)
Discussion started by: anish
4 Replies

6. Programming

question about int arrays and file pointer arrays

if i declare both but don't input any variables what values will the int array and file pointer array have on default, and if i want to reset any of the elements of both arrays to default, should i just set it to 0 or NULL or what? (1 Reply)
Discussion started by: omega666
1 Replies

7. Shell Programming and Scripting

How can I use the arrays ?

Hi all, I have a file test1.txt with the below contents abc def ghj xyz I tried printing these values using arrays. Script tried : =========== set -A array1 `cat test1.txt` count=${#array1 } i=0 while do echo "element of array $array1" done (1 Reply)
Discussion started by: dnam9917
1 Replies

8. Programming

Arrays in C++

I've noticed something interesting in C++ programming. I've always done tricky stuff with pointers and references to have functions deal with arrays. Doing exercises again out of a C++ book has shown me an easier way, I didn't even know was there. It's weird to me. When dealing with arrays, it... (4 Replies)
Discussion started by: John Tate
4 Replies

9. Shell Programming and Scripting

Using arrays?

I have never used arrays before but I have a script like this: var1=$(for i in $(cat /tmp/jobs.021013);do $LIST -job $i -all | perl -ne 'print /.*(\bInfo.bptm\(pid=\d{3,5}).*/' | tr -d "(Info=regpid" | tr -d ')'; $LIST -job $i -all | cut -f7 -d','| sed -e "s/^\(*\)\(*\)\(*\)\(.*\)/\1... (2 Replies)
Discussion started by: newbie2010
2 Replies

10. UNIX for Dummies Questions & Answers

Arrays

Am using bash For eg: Suppose i have a array arr=(1 2 3 4 5 6 7 8 9 10 11 12) suppose i give input 5 to a script and script should able to print values greater than or equal to 5 like below: Input: 5 output: 5,6,7,8,9,10,11,12 (7 Replies)
Discussion started by: manid
7 Replies
lpana(1M)																 lpana(1M)

NAME
lpana - display LP spooler performance analysis information SYNOPSIS
dest] DESCRIPTION
displays LP spooler performance information, which system administrators can use to optimize the configuration of the entire spooler sys- tem. Options recognizes one option: Choose dest as the printer or the class of printers. If dest is a printer, the performance analysis information is dis- played for that specific printer. If dest is a class of printers, the performance analysis information is displayed for the printers that are members of the class. By default, displays the performance analysis information for all printers and/or classes. examines for the following items: Average waiting time from when job is spooled until start of printing. Standard Deviation for waiting time. Average printing time from start to end of job. Standard Deviation for printing time. Average of number of bytes printed per request. Standard Deviation for number of bytes. Sum of bytes printed for all requests (in kilobytes). Total number of requests since logging started. EXTERNAL INFLUENCES
Environment Variables determines the language in which messages are displayed. Setting causes the destination names exceeding 14 characters to be wrapped to multiple lines. This will ensure proper indentation of all the other displayed fields. WARNINGS
performs its operation on the local system only. AUTHOR
was developed by HP. FILES
SEE ALSO
lp(1), lpstat(1), lpadmin(1M), lpsched(1M). lpana(1M)
All times are GMT -4. The time now is 04:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy