My code is at :-
What im doing is grab the "position" which is $1 in this file for specified $3(line number), So let say i am intrerested to find out line number 321 score.
Since the score of 321 is 0.5555, I wanted to handle 2 cases.
1st) If there are any other elements before or after whcih have same score,
i need to compare the position ($1) and take the min(first seen minimum position which have the score 0.5555) and take the max(last seen maximum position which have score 0.5555). This should return us position 10 for min
and 12 for max.
2nd) If (in other case) there are no other elements with similar score, i will just take the first and only position which have score of 0.5555 which in this case should return us 11.
I tried to load the above input but it seems not able to compare properly to find the min and max. It returns me 10 as min and "nothing" for max. For your info, I print out as echo -e...
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)
Hi,
I need your kind help to get min and max values from file based on value in $5 .
File1
SP12.3 stc 2240806 2240808 + ID1_N003 ID2_N003T0
SP12.3 sto 2241682 2241684 + ID1_N003 ID2_N003T0
SP12.3 XE 2239943 2240011 + ID1_N003 ID2_N003T0
SP12.3 XE 2240077 2241254 + ID1_N003 ... (12 Replies)
aaa: 3 ms
aaa: 2 ms
aaa: 5 ms
aaa: 10 ms
..........
to get the 3 2 5 10 ...'s min avg and max
something like
min: 2 ms avg: 5 ms max: 10 ms (2 Replies)
Dear all,
I have 2 questions.
I have a file with many rows which has date of the format YYYYMMDD.
1. I need to change the date to that weeks friday date(Ex: 20120716(monday) to 20120720). Satuday/Sunday has to be changed to next week friday date too.
2. After converting the date to... (10 Replies)
I have to find the min and max on a specific column in a file after sending that column and one other to a output file but I keep getting a maximum of zero
below is what i have so far if anyone can give me advice on what i am doing wrong the help would be much appreciated
# ! /usr/bin/perl -w... (2 Replies)
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
a 1 4
b 2 5
c 3 6
I want ouput like:
cat file.txt
a 1 4
b 2 5
c 3 6
Max 3 6
Min 1 4
Diff 2 2
awk 'min=="" ||... (4 Replies)
Hi,
I have a text file containing numbers. There are up to 6 numbers per row and I need to read them, check if they are 0 and if they are not zero check if they are within a given interval (min,max). If they exceed the max or min they should be set to max or min respectively, if they are in the... (4 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)