Hello Experts,
I have got a txt files which has multiple columns, I want to get the max, min and diff (max-min) for each column in the same txt file. Example:
cat file.txt
Code:
a 1 4
b 2 5
c 3 6
I want ouput like:
cat file.txt
Code:
a 1 4
b 2 5
c 3 6
Max 3 6
Min 1 4
Diff 2 2
Code:
awk 'min=="" || $2 < min {min=$2} END{print min}' file.txt
this awk command can find min from 2 column, but i have to change the column number, is there a one liner which can give me desired output in the same text file.
Thanks in advance.
Last edited by joeyg; 04-04-2012 at 04:29 PM..
Reason: corrected spelling, added CodeTags
Hi
I wanted to write a shell script with an if condition
Example
MinValue=10
MaxValue=30
logvalue = some integer value that script reads from the command line arguement
I wanted to check whether log value greater than or equal to10 and less than equal to 30
and proceed with the rest of... (5 Replies)
hello friends...:-)
i need some help
i have a file cantain like this
Star1 ,NetWork,09/02/2008
Star1 ,NetWork,10/02/2008
Star1 ,NetWork,11/02/2008
Star2 ,NetWork,08/03/2008
Star2 ,NetWork,09/04/2008
Star2 ,NetWork,10/05/2008
i need to find out min, max dates
the output look like... (6 Replies)
hi!
i have a file like the attachement.
I'd like to get for each line the min, max and average values. (there is 255 values for each line)
how can i get that ?
i try this, is it right?
BEGIN {FS = ","; OFS = ";";max=0;min=0;moy=0;total=0;freq=890}
$0 !~ /Trace1:/ {
... (1 Reply)
Hi all,
Ive searched the forum but with no luck...
I have a file:
ID Name Val
1 bob 45
2 joe 89
3 sue 11
4 steve 89
...
etc
I want to find a way to print... (6 Replies)
Hi ,
Below is my sample data,I have this 8 column(A,B,C,D,E,F,G,H) in csv file.
A , B ,C ,D ,E ,F,G ,H
4141,127337,24,15,20,69,72.0,-3
4141,128864,24,15,20,65,66.0,-1
4141,910053,24,15,4,4,5.0,-1
4141,910383,24,15,22,3,4.0,-1
4141,496969,24,15,14,6,-24.0,-18... (7 Replies)
I need to find the max/min of columns 1 and 2 of a 2 column file what contains the special character ">".
I know that this will find the max value of column 1.
awk 'BEGIN {max = 0} {if ($1>max) max=$1} END {print max}' input.file
But what if I needed to ignore special characters in the... (3 Replies)
Gents,
I have a big file file like this.
5100010002
5100010004
5100010006
5100010008
5100010010
5100010012
5102010002
5102010004
5102010006
5102010008
5102010010
5102010012
The file is sorted and I would like to find the min and max value, taking in the consideration key1... (3 Replies)
You have a log file as attached in sample input with various operations and time taken by each of them. Write a script to find the min and max time taken for each operation. Sample output is attached.
Sample Input is given as below:
operation1,83621
operation2,72321
operation3,13288... (1 Reply)
Discussion started by: Chandan_Bose
1 Replies
LEARN ABOUT PHP
mt_rand
MT_RAND(3) 1 MT_RAND(3)mt_rand - Generate a better random valueSYNOPSIS
int mt_rand (void )
DESCRIPTION
int mt_rand (int $min, int $max)
Many random number generators of older libcs have dubious or unknown characteristics and are slow. By default, PHP uses the libc random
number generator with the rand(3) function. The mt_rand(3) function is a drop-in replacement for this. It uses a random number generator
with known characteristics using the Mersenne Twister, which will produce random numbers four times faster than what the average libc
rand() provides.
If called without the optional $min, $max arguments mt_rand(3) returns a pseudo-random value between 0 and mt_getrandmax(3). If you want a
random number between 5 and 15 (inclusive), for example, use mt_rand(5, 15).
Caution
This function does not generate cryptographically secure values, and should not be used for cryptographic purposes. If you need a
cryptographically secure value, consider using random_int(3), random_bytes(3), or openssl_random_pseudo_bytes(3) instead.
PARAMETERS
o $min
- Optional lowest value to be returned (default: 0)
o $max
- Optional highest value to be returned (default: mt_getrandmax(3))
RETURN VALUES
A random integer value between $min (or 0) and $max (or mt_getrandmax(3), inclusive), or FALSE if $max is less than $min.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.3.4 | |
| | |
| | Issues an E_WARNING and returns FALSE if $max < |
| | $min. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
mt_rand(3) example
<?php
echo mt_rand() . "
";
echo mt_rand() . "
";
echo mt_rand(5, 15);
?>
The above example will output something similar to:
1604716014
1478613278
6
NOTES
Caution
The distribution of mt_rand(3) return values is biased towards even numbers on 64-bit builds of PHP when $max is beyond 2^32. This
is because if $max is greater than the value returned by mt_getrandmax(3), the output of the random number generator must be scaled
up.
SEE ALSO mt_srand(3), mt_getrandmax(3), random_int(3), random_bytes(3), openssl_random_pseudo_bytes(3), rand(3).
PHP Documentation Group MT_RAND(3)