Try with this. What modified? In case fifth field is an alphabetic character, asign the ninth column to value variable, else assign the eigth one. And work with that.
Regards,
Birei
Hello every one, I have following data
***CAMPAIGN 1998 CONTRIBUTIONS***
---------------------------------------------------------------------------
NAME PHONE Jan | Feb | Mar | Total Donated
... (12 Replies)
How can I extract few lines(like 10 to 15, top 10 and last 10) from a file using perl.
I do it with sed, head and tail in unix scripting. I am new to perl. Appreciate your help. (2 Replies)
hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value.
BEGIN {FS=","; max=0}
NF == 7 {if (max < $6) max = $6;}
END { print man, min}
where $6 is the column of a field separated by a comma (3 Replies)
I'm trying to iterate a UNIX awk script that returns min/max temperature data for each day from a monthly weather data file (01_weath.dat). The temperature data is held in $5. The temps are reported each minute so each day contains 1440 temperature enteries. The below code has gotten me as far as... (5 Replies)
I am trying to print 1st, 2nd, 13th and 14th fields of a file of line numbers from 29 to 10029. I dont know how to put this in one code. Currently I am removing the selected lines by
awk 'NR==29,NR==10029' File1 > File2
and then doing
awk '{print $1, $2, $13, $14}' File2 > File3
Can... (3 Replies)
Hi guys,
I already search on the forum but i can't solve this on my own.
I have a lot of files like this:
And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in... (4 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)
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)
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)
TAU_GET_EVENT_VALS(3) TAU Instrumentation API TAU_GET_EVENT_VALS(3)NAME
TAU_GET_EVENT_VALS - Gets user event data for given user events.
SYNOPSIS
C/C++:
TAU_GET_EVENT_VALS(const char **inUserEvents, int numUserEvents, int **numEvents, double **max, double **min, double **mean,
double **sumSqe);
DESCRIPTION
Retrieves user defined event data for the specified user defined events. The list of events are specified by the first parameter
(eventList) and the user specifies the number of events in the second parameter (numUserEvents). TAU returns the number of times the event
was invoked in the numUserEvents. The max, min, mean values are returned in the following parameters. TAU computes the sum of squares of
the given event and returns this value in the next argument (sumSqe).
EXAMPLE
C/C++ :
const char **eventList;
int numEvents;
TAU_GET_EVENT_NAMES(eventList, numEvents);
cout << "numEvents: " << numEvents << endl;
if (numEvents > 0) {
int *numSamples;
double *max;
double *min;
double *mean;
double *sumSqr;
TAU_GET_EVENT_VALS(eventList, numEvents, numSamples,
max, min, mean, sumSqr);
for (int i=0; i<numEvents; i++) {
cout << "-------------------
";
cout << "User Event: " << eventList[i] << endl;
cout << "Number of Samples: " << numSamples[i] << endl;
cout << "Maximum Value: " << max[i] << endl;
cout << "Minimum Value: " << min[i] << endl;
cout << "Mean Value: " << mean[i] << endl;
cout << "Sum Squared: " << sumSqr[i] << endl;
}
}
}
SEE ALSO TAU_REGISTER_EVENT(3), TAU_REGISTER_CONTEXT_EVENT(3), TAU_GET_EVENT_NAMES(3)
08/31/2005 TAU_GET_EVENT_VALS(3)