07-27-2012
Thanks neutronscott.
After adding up the two columns with rdcwayx's command, I had the output in form of one column. That column can have 15,16 or any number of values. My question was how to get the sum of all those values.
For example:
HTML Code:
Output:
12
5
8
10
I want to get the sum of the values: 12+5+8+10=35. But I do not know how many values will be in the output, because output is different on each server.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I would like to know given that I have 3 columns.
Let say I have first 3 columns to do operation and these operation output is printed out each line by line using AWK and associative array.Currently in the output file, I do a sort by -r for the operation output.
The problem comes to... (1 Reply)
Discussion started by: ahjiefreak
1 Replies
2. Shell Programming and Scripting
Hi Everyone:
My shell script creates multiple csv files (~30) in for loop. I want to compile (or merge) 3rd column from each (all) of these files to another file (in loop). Please help. Thanks. (3 Replies)
Discussion started by: smap007
3 Replies
3. Shell Programming and Scripting
Im very new to programming. But I would like to write a script which extracts and multiply values from 2 txt and output as a new file. Can someone please teach me how to write it? Thank you so much
for example
File A File B
1 34 1 2
2 13 2 2
3 8 3 3
File C output
1 68
2... (2 Replies)
Discussion started by: crunchichichi
2 Replies
4. UNIX for Dummies Questions & Answers
Hello everybody,
I have a text file containing 10,000 rows and 5000 columns. The values are separated by a tab.
Ex.
file_ex.ped
1 mike 0 0 2 1 A A G G C T A G
1 jack 0 0 2 2 T A G T C A A C
1 Mary 0 0 1 2 A T G C A T G C
...
I would like a out put file
1 mike 0 0 2 1 AA GG CT AG
1... (7 Replies)
Discussion started by: Unilearn
7 Replies
5. Shell Programming and Scripting
a=10.02
pattern=-11.01
b=$(echo | awk '{ print $a*$pattern}')
echo $b
its not working even
ALso tried `expr $a \* $pattern`
No LUCK (3 Replies)
Discussion started by: saluja.deepak
3 Replies
6. UNIX for Dummies Questions & Answers
Hello,
I have a file with 5 columns that looks like this:
A1BG chr19 + 58863335 58866549
A1BG chr19 - 58858171 58864865
A2LD1 chr13 - 101182417 101186056
A2LD1 chr13 - 101182417 101241046
A2M chr12 - 9220303 9268558
A2ML1 ... (5 Replies)
Discussion started by: wolf_blue
5 Replies
7. UNIX for Dummies Questions & Answers
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies
8. Shell Programming and Scripting
Hi All,
My file has the records as below:
aaa\bbb\c\dd\ee\ff\gg
zz\vv\ww
pp\oo\ii\uu
How can I get the value after the last delimeter.
My o/p:
gg
ww
uu
Thanks in Advance, (5 Replies)
Discussion started by: HemaV
5 Replies
9. Shell Programming and Scripting
I have 2 files, that look like this:
ID SNP1 SNP2 SNP3 SNP4
A1 1 2 0 2
A2 2 0 1 1
A3 0 2 NA 1
A4 1 1 0 2
and this:
SNP score
SNP1 0.5
SNP2 0.7
SNP3 0.8
SNP4 0.2
Basically, all of the SNP-values are 0,1, 2 or NA, and they each have a score, listed in the second file. The total... (5 Replies)
Discussion started by: kayakj
5 Replies
10. UNIX for Beginners Questions & Answers
Columns 4 and 5 are X and Y coordinates, column 6 is the elevation
I would like to add 2 new columns at the end of the file with values
the distance between first(X)(Y) and last location (X)(Y), based in 2 rows
the difference in elevation = ($6-prev6)
How to calculate the requested values... (6 Replies)
Discussion started by: jiam912
6 Replies
LEARN ABOUT PHP
db2_field_precision