05-13-2008
Hi Saniya,
Try this
#!/bin/ksh
count=0
Threshold=5000
while read line
do
val=`echo $line | cut -d" " -f10 | cut -d"=" -f3`
if [ $val -ge $Threshold ]
then
count=`expr $count + 1`
fi
done < 0003080248636880.txt
echo "Number of Values above threshold is $count"
total=`grep -c "interactionCompleted" 0003080248636880.txt`
echo "Total is $total"
s=`echo "scale=4 ; $count/$total" | bc `
echo "Average is $s"
Thanks
Penchal
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Can anyone explain to me why the first line doesn't work and the second seems to work fine. I am trying to find all occurances of text within a certain column (col 13) that start with the character V, I suppose it sounds simple but I have tried using the following but don't really understand what... (2 Replies)
Discussion started by: Gerry405
2 Replies
2. Shell Programming and Scripting
hi,
i have the command nawk -v i want to use it equivalent in awk?
any help please
:) (2 Replies)
Discussion started by: kamel.seg
2 Replies
3. Solaris
Hi
Running a specific nawk statement over a 17m lines files returns the following:
/bin/nawk: not enough args in .....
input record number 1,25955e+06, file test.1
source line number 1
I'd like to report the line number (in bold above) in decimal not floating so that i can spot it out.
... (1 Reply)
Discussion started by: moutaye
1 Replies
4. Shell Programming and Scripting
Hi
Running a specific nawk statement over a 17m lines files returns the following:
/bin/nawk: not enough args in .....
input record number 1,25955e+06, file test.1
source line number 1
I'd like to report the line number (in bold above) in decimal not floating so that i can spot it out.
... (1 Reply)
Discussion started by: moutaye
1 Replies
5. UNIX for Dummies Questions & Answers
Hi ,
i try to filter input file :
17/04/2008 06:17:09
17/04/2008 00:00:02
keeping lines with hour > 06
as :
17/04/2008 06:17:09
i tried :
CSL=06
nawk -v CSL="${CSL}" -F'' '/^\[/ { if ( $4 -gt $CSL) print $0 } ; /^\>/ { if ( $5 -gt $CSL) print $0 }' input_file.txt... (11 Replies)
Discussion started by: Nicol
11 Replies
6. UNIX for Dummies Questions & Answers
Hi all,
I can run the following script using nawk..However, I find that teh server dun support nawk.. May I know how to change teh script to use awk such that it will work? Very urgent.. thx!
nawk 'BEGIN {FS=OFS=","}
NR==FNR{arr=$2;next}
$0 !~ "Documentation"{print $0;next} ... (2 Replies)
Discussion started by: kinmak
2 Replies
7. Shell Programming and Scripting
Hi Guys,
i tried these two commands. First in awk and nawk.
The nawk command is running fine but the awk command is throwing error.
What is wrong with the awk command. There are lot of awk commands running fine in my system
d003:/usr/local/dsadm/dsprod>nawk 'NR = 1 {print " "$0}' a.txt
... (6 Replies)
Discussion started by: mac4rfree
6 Replies
8. UNIX for Dummies Questions & Answers
Hi everyone,
i am new to unix , so i want to know what is the use of awk and nawk.
because in most of the place this cmds were used.
so, if anyone provied the basic idea of this cmds, it will be much helpfull for me . . ..
Thnks in Advance :) (9 Replies)
Discussion started by: natraj005
9 Replies
9. Shell Programming and Scripting
Hi Guys,
I am in need of some help; I have an xml message file which contains personal details as shown below:
, message=, message=, message=, message=, message=, message=
I want to use nawk to parse these xml messages but I am new to awk and nawk.
What I want is to get output... (7 Replies)
Discussion started by: James_Owen
7 Replies
MIN(3) 1 MIN(3)
min - Find lowest value
SYNOPSIS
mixed min (array $values)
DESCRIPTION
mixed min (mixed $value1, mixed $value2, [mixed $...])
If the first and only parameter is an array, min(3) returns the lowest value in that array. If at least two parameters are provided,
min(3) returns the smallest of these values.
Note
Values of different types will be compared using the standard comparison rules. For instance, a non-numeric string will be com-
pared to an integer as though it were 0, but multiple string values will be compared alphanumerically. The actual value returned
will be of the original type with no conversion applied.
PARAMETERS
o $values
- An array containing the values.
o $value1
- Any comparable value.
o $value2
- Any comparable value.
o $...
- Any comparable value.
RETURN VALUES
min(3) returns the parameter value considered "lowest" according to standard comparisons. If multiple values of different types evaluate as
equal (e.g. 0 and 'abc') the first provided to the function will be returned.
EXAMPLES
Example #1
Example uses of min(3)
<?php
echo min(2, 3, 1, 6, 7); // 1
echo min(array(2, 4, 5)); // 2
// The string 'hello' when compared to an int is treated as 0
// Since the two values are equal, the order they are provided determines the result
echo min(0, 'hello'); // 0
echo min('hello', 0); // hello
// Here we are comparing -1 < 0, so -1 is the lowest value
echo min('hello', -1); // -1
// With multiple arrays of different lengths, min returns the shortest
$val = min(array(2, 2, 2), array(1, 1, 1, 1)); // array(2, 2, 2)
// Multiple arrays of the same length are compared from left to right
// so in our example: 2 == 2, but 4 < 5
$val = min(array(2, 4, 8), array(2, 5, 1)); // array(2, 4, 8)
// If both an array and non-array are given, the array is never returned
// as comparisons treat arrays as greater than any other value
$val = min('string', array(2, 5, 7), 42); // string
// If one argument is NULL or a boolean, it will be compared against
// other values using the rule FALSE < TRUE regardless of the other types involved
// In the below examples, both -10 and 10 are treated as TRUE in the comparison
$val = min(-10, FALSE, 10); // FALSE
$val = min(-10, NULL, 10); // NULL
// 0, on the other hand, is treated as FALSE, so is "lower than" TRUE
$val = min(0, TRUE); // 0
?>
SEE ALSO
max(3), count(3).
PHP Documentation Group MIN(3)