@RudiC:
I don't really get the END section of your code. Specially the "tmp[2]" !??? And what is the separator in "split(line[i],temp)" ? Is it "\n" by default ?
I tried to modify your code in the case I have a third field specifying subgroup in the input file:
Code:
1%2%3%4%;AA;1
5%6%7%8%9;AA;1
1%2%3%4%5%6;BB;2
7%8%9%10%11%12;BB;2
13%14%15%16%17%18;BB;3 # note te third field is different then the previous "BB" groups
and obtain that at the end:
Code:
1%2%3%4%;AA;1;1-5%2-6%3-7%4-8%0-9% # unchanged
5%6%7%8%9;AA;1;1-5%2-6%3-7%4-8%0-9% # unchanged
1%2%3%4%5%6;BB;2;1-7%2-8%3-9%4-10%5-11%6-12% #unchanged
7%8%9%10%11%12;BB;2;1-7%2-8%3-9%4-10%5-11%6-12% # unchanged
13%14%15%16%17%18;BB;3;13%14%15%16%17%18 # $4 is same as $1 as this record is the only one in "BB;3" group
I changed your previous code as follow:
Code:
BEGIN{FS=OFS=";"}
{line[NR] = $0
a = split ($1, b, "%")
for (i=1; i<=a; i++)
{b[i]=b[i]?b[i]:"0";
if ((!MIN [$2$3,i]) || (MIN [$2$3,i] > b[i])) MIN [$2$3,i] = b[i]
if ((!MAX [$2$3,i]) || (MAX [$2$3,i] < b[i])) MAX [$2$3,i] = b[i]
}
if (a > maxfld[$2$3]) maxfld[$2$3] = a
}
END {for (i=1; i<=NR; i++)
{printf "%s;", line[i]
split (line[i], tmp)
for (j=1; j<=maxfld[tmp[3]]; j++)
printf ("%s-%s%%", MIN[tmp[3],j], MAX[tmp[3],j])
printf "\n"
}
}
Last edited by beca123456; 02-13-2013 at 10:50 PM..
Hi,
I have this input file called ttbitnres (which is catenated and sorted):-
8 0.4444 213
10 0.5555 342
11 0.5555 321
12 0.5555 231
13 0.4444 400
My code is at :-
#!/bin/bash
echo -e Version "\t" Number of Pass "\t" Number of Fail "\t" Rank Position "\t"Min "\t" Max... (1 Reply)
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,
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)
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)
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)
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)
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)
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)
Discussion started by: jiam912
3 Replies
LEARN ABOUT DEBIAN
alzabo::sqlmaker::postgresql
Alzabo::SQLMaker::PostgreSQL(3pm) User Contributed Perl Documentation Alzabo::SQLMaker::PostgreSQL(3pm)NAME
Alzabo::SQLMaker::PostgreSQL - Alzabo SQL making class for PostgreSQL
SYNOPSIS
use Alzabo::SQLMaker;
my $sql = Alzabo::SQLMaker->new( sql => 'PostgreSQL' );
DESCRIPTION
PostgreSQL-specific SQL creation.
METHODS
Almost all of the functionality inherited from "Alzabo::SQLMaker" as is. The only overridden methods are "limit()" and "get_limit()", as
PostgreSQL does allow for a "LIMIT" clause in its SQL.
EXPORTED SQL FUNCTIONS
SQL may be imported by name or by tags. They take arguments as documented in the PostgreSQL documentation (version 3.23.39). The func-
tions (organized by tag) are:
:math
PI
RANDOM
ABD
CEIL
DEGREES
FLOOR
FACTORIAL
SQRT
CBRT
EXP
LN
RADIANS
ACOS
ASIN
ATAN
ATAN2
COS
COT
SIN
TAN
ROUND
TRUNC
LOG
POW
MOD
TO_CHAR
:string
LENGTH
CHAR_LENGTH
CHARACTER_LENGTh
OCTET_LENGTH
TIRM
UPPER
LOWER
INITCAP
ASCII
TO_ASCII
STRPOS
POSITION
TO_NUMBER
TO_DATE
TO_TIMESTAMP
REPEAT
RPAD
LPAD
SUBSTR
:datetime
NOW
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
TIMEOFDAY
ISFINIT
TIMESTAMP
TO_CHAR
DATE_PART
DATE_TRUNC
EXTRACT
OVERLAPS
:network
BROADCAST
HOST
NETMASK
MASKLEN
NETWORK
TEXT
ABBREV
:aggregate
These are functions which operate on an aggregate set of values all at once.
COUNT
AVG
MIN
MAX
SUM
STDDEV
VARIANCE
:system
These are functions which return information about the Postgres server.
CURRENT_USER
SYSTEM_USER
USER
:control
These are flow control functions:
NULLIF
COALESCE
:misc
These are functions which don't fit into any other categories.
ENCRYPT
ENCODE
DECODE
FORMAT
INET_NTOA
INET_ATON
BIT_OR
BIT_AND
PASSWORD
MD5
LOAD_FILE
:common
These are functions from other groups that are most commonly used.
NOW
COUNT
AVG
MIN
MAX
SUM
DISTINCT
AUTHOR
Dave Rolsky, <dave@urth.org>
perl v5.8.8 2007-12-23 Alzabo::SQLMaker::PostgreSQL(3pm)