06-10-2009
need an awk script/logic
In one data file i have values like this
a b c 1 2
e f g 2 3
i j k 3 5
I need to sum up the last 2 columns and make a data file...How i can do that.
a b c 1 2
e f g 2 3
i j k 3 5
------------------------------------
total 6 10
Please suggest me some ideas.
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello friends,
I have a problem in printing an array..
Example if my array line contains 4 elements like following
line=0002 , line=202200, line=200002, line= 300313
Now one = sprintf line line line line will concatenate my whole array to one.
But I am not sure about the... (7 Replies)
Discussion started by: user_prady
7 Replies
2. Shell Programming and Scripting
Hello Friends,
I have a txt file like below
//*Init Start
Reg(read,12'h42E,16'h0000);
Nop(5628.5);
//*Init End
//*Main Start
Reg(read,12'h42E,16'h0000);
Nop(5628.5);
//*Main End
I want to calculate the values between //* Init Start & //* Init End
And //*Main Start & //*Main... (5 Replies)
Discussion started by: user_prady
5 Replies
3. Shell Programming and Scripting
Hi Friends,
I got stuck where to start with ..
I ve a input file like below. where I want to compare write data with my read data .. The problem is that the read data should be compared with the lastest write data on that address.
Note- Both write data & read data are in the same... (8 Replies)
Discussion started by: user_prady
8 Replies
4. Shell Programming and Scripting
I want to print lines that have "IND" or "ind" or nothing in field 2 or 3
file:
output needed:
Code i wrote:
nawk -F"," '{if(tolower($2||$3) ~"ind"||"")print}' file
Help is appreciated (3 Replies)
Discussion started by: pinnacle
3 Replies
5. UNIX for Dummies Questions & Answers
I have task to find out the min,max, average value of each service for example i searched for " StatementService "
$awk '/VST.*StatementService:/{print $3,$4,$19,$22,$25}' performance.log > smp.log
$cat smp.log
amexgtv VST: : StatementService:1860 StatementService:getCardReference:0... (3 Replies)
Discussion started by: senthil.ak
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
My file has 2 fields and millions of lines.
variableStep chrom=Uextra span=25
201 0.5952
226 0.330693
251 0.121004
276 0.0736858
301 0.0646982
326 0.0736858
401 0.2952
426 0.230693
451 0.221004
476 0.2736858
Each field either has a... (6 Replies)
Discussion started by: wyarosh
6 Replies
7. Shell Programming and Scripting
Hi friends, I am having 2 files, I just want to compare 2 files each containing 2 columns 1st column is lat, and 2nd column is long, if anyone can understand below logic please help me in writing script with awk.. here each field of file2 needs to be compared with std_file
main
counter=0... (1 Reply)
Discussion started by: Akshay Hegde
1 Replies
8. Shell Programming and Scripting
I am trying to check my logic on a long awk i'm using. I have about 30 checks that I built into an awk and I "believe" I did this right, but I could be wrong.
awk -F\| '
$9 !~ /\/*{1,}*/
$9 ~ /\(-{4}, {2,3}/
$9 ~ /\({6}, {2,3}\)/
$9 ~ /\(\+{5}, {2,3}\)/
$9 ~ /\(\+\+{4}, {2,3}\)/
$9 ~... (8 Replies)
Discussion started by: dagamier
8 Replies
HISTO(1) General Commands Manual HISTO(1)
NAME
histo - compute 1-dimensional histogram of N data columns
SYNOPSIS
histo [-c][-p] xmin xmax nbins
histo [-c][-p] imin imax
DESCRIPTION
Histo bins columnular data on the standard input between the given minimum and maximum values. If three command line arguments are given,
the third is taken as the number of data bins between the first two real numbers. If only two arguments are given, they are both assumed
to be integers, and the number of data bins will be equal to their difference plus one. The bins are always of equal size.
The output is N+1 columns of data (for N columns input), where the first column is the centroid of each division, and each row corresponds
to the frequencies for each column around that value.
If the -c option is present, then histo computes the cumulative histogram for each column instead of the straight frequencies. The upper
value of each bin is printed also instead of the centroid. This may be useful in computing percentiles, for example. Values below the
minimum specified are still counted in the cumulative total.
The -p option tells histo to report the percentage of the total number of input lines rather than the absolute counts. In the case of a
cumulative total, this yields the percentile values directly. Values above the maximum are counted as well as values below in this case.
All input data is interpreted as real values, and columns must be white-space separated. If any value is less than the minimum or greater
than the maximum, it will be ignored unless the -c option is specified.
EXAMPLE
To count data values between -1 and 1 in 50 bins:
histo -1 1 50 < input.dat
To count frequencies of integers between 0 and 255:
histo 0 255 < input.dat
AUTHOR
Greg Ward
SEE ALSO
cnt(1), neaten(1), rcalc(1), rlam(1), tabfunc(1), total(1)
RADIANCE
9/6/96 HISTO(1)