12-13-2007
I'm good so far, thanks everyone for the info about the tabs. Now I'm trying to calculate the average of a particular field. I know tot(and then the field name)+= will total it, but what about an average?
Trellot
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hey guys can you please help me out,
i'm having problem in cutting strings. I need a delimiter to cut string.
sample
a.txt
"ID", "1234" , "iam bighippo", "help!"
"ID", "1235" , "again0", "xxxxxxx1"
"ID", "1236" , "again1", "xxxxxxx2"
"ID", "1237" , "again2", "xxxxxxx3"
how do... (6 Replies)
Discussion started by: bighippo
6 Replies
2. UNIX for Dummies Questions & Answers
I am having the following file. I need to insert a delimiter in this file. I used sed but its not working.
AAABBB 9 JJJ
AAABBC 9 TTTTT
AAABBA 8 JJJ
AAABBC 7 TTTTT
AAABBC 6 TTTTT
Now i want the output file as:
AAA|BBB| |9| |JJJ|
AAA|BBC| |9| | |TTTTT| (3 Replies)
Discussion started by: sivakumar.rj
3 Replies
3. Shell Programming and Scripting
Hi,
I have a string like ABC.123.XYZ-A1-B2-P1-C4. I want to delimit the string based on "-" and then get result as only two strings. One with string till last hyphen and other with value after last hyphen... For this case, it would be something like first string as "ABC.123.XYZ-A1-B2-P1" and... (6 Replies)
Discussion started by: gupt_ash
6 Replies
4. Shell Programming and Scripting
Hi,
I am trying to load data from a file to oracle DB. The file am using has a ";" as a delimiter. While I load the file, I want to check whether the file is having the correct delimiter or not. if not, the file should not be processed. Is there any way that i could handle this scenario using... (3 Replies)
Discussion started by: smileyreddy
3 Replies
5. Shell Programming and Scripting
Hi all,
I have a number of strings like below:
//mnt/autocor/43°13'(33")W/
and i'm trying to get the numbers in this string, for example
431333
please help
thanks ahead (14 Replies)
Discussion started by: sunnydanniel
14 Replies
6. Shell Programming and Scripting
hi all,
i have a string with a number of "/"s as delimiter.
and i want everything BEFORE the last delimiter
i know to use basename to get everything after the last delimiter.
thx a lot! (2 Replies)
Discussion started by: sunnydanniel
2 Replies
7. Shell Programming and Scripting
Hi,
I have a No Delimiter variable length text file with following schema -
Column Name Data length
Firstname 5
Lastname 5
age 3
phoneno1 10
phoneno2 10
phoneno3 10
sample data - ... (16 Replies)
Discussion started by: Gaurav Martha
16 Replies
8. Solaris
Trying to figure out the best method of security for oracle user accounts. In Solaris 10 they are set as regular users but have nologin set forcing the dev's to login as themselves and then su to the oracle users.
In Solaris11 we have the option of making it a role because RBAC is enabled but... (1 Reply)
Discussion started by: os2mac
1 Replies
9. Shell Programming and Scripting
Hi,
Extremely new to Perl scripting, but need a quick fix without using TEXT::CSV
I need to read in a file, pass any delimiter as an argument, and convert it to bar delimited on the output. In addition, enclose fields within double quotes in case of any embedded delimiters.
Any help would... (2 Replies)
Discussion started by: JPB1977
2 Replies
10. UNIX for Dummies Questions & Answers
How to split 2:6..5 in to separate columns (7 Replies)
Discussion started by: Nadela
7 Replies
LEARN ABOUT DEBIAN
lire::average
Average(3pm) LogReport's Lire Documentation Average(3pm)
NAME
Lire::Average - Lire class that implements the avg operator
SYNOPSIS
use Lire::Average
DESCRIPTION
Class that implements the avg operator. This operator will compute the average value of a DLF field in a group of DLF records.
If the field used by average isn't a numeric fields, the number of different values in that field will be used as the numerator.
It's possible to compute a weighted average by specifying a weighting field.
By default, the average is a by record average. It's possible to compute a by different values average. The list of fields that's used to
determine the different values if speficied in the by-fields attribute.
METHODS
new( %params )
Creates a new Lire::Average object. In addition to the values supported by its parents, the by-fields and weight attributes will be
initialized to the values specified in the %params argument.
by_fields( [$new_by_fields] )
Returns the fields that are going to be used to count the different values which will made up the by part of the average.
This a reference to an array of DLF field names.
If the $new_by_fields parameter is set, it will be used as the new $by_fields value. It must be an array reference and should only contains
valid field names for the current report specification's schema.
weigth( [$new_weight] )
Returns the DLF field's name by which the values will be multiplied before being summed.
You can change the weight field by specifying a new name as the $new_weight parameter. Use undef to remove the use of a weighting field.
SEE ALSO
Lire::ReportSpec(3pm), Lire::ReportOperator(3pm),
Lire::Aggregator(3pm), Lire::Aggregate(3pm).
AUTHORS
Francis J. Lacoste <flacoste@logreport.org>
Wolfgang Sourdeau <wsourdea@logreport.org>
VERSION
$Id: Average.pm,v 1.17 2008/03/09 19:27:30 vanbaal Exp $
COPYRIGHT
Copyright (C) 2001-2004 Stichting LogReport Foundation LogReport@LogReport.org
This file is part of Lire.
Lire is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
Lire 2.1.1 2008-03-09 Average(3pm)