05-12-2009
Parse 1 column and add 2nd column
I'm racking my brain on this one!
I have a list like this:
Paul 20
Paul 25
Paul 30
Frank 10
Julie 15
Julie 13
etc, etc...
I've been trying to figure out a way to have the output display the name in the first column ONCE and add the numbers in the second column and display that next to the name:
Paul 75
Frank 10
Julie 28
I've tried all sort of combination's of 'sed', 'awk' and 'uniq' and no matter what I try I cannot get a single name output with a total.
Thoughts??? Hints?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
So I have this input
1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI
1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI
1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI
1 10583 rs58108140 G A ... (3 Replies)
Discussion started by: kellywilliams
3 Replies
2. Shell Programming and Scripting
Hi friends,
My file is like:
Second file is :
I need to print the rows present in file one, but in order present in second file....I used
while read gh;do
awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile
done < secondfile
but the output I am... (14 Replies)
Discussion started by: CAch
14 Replies
3. Shell Programming and Scripting
Hi All,
I have following html code
<TR><TD>9</TD><TD>AR_TVR_TBS </TD><TD>85000</TD><TD>39938</TD><TD>54212</TD><TD>46</TD></TR>
<TR><TD>10</TD><TD>ASCV_SMY_TBS </TD><TD>69880</TD><TD>33316</TD><TD>45698</TD><TD>47</TD></TR>
<TR><TD>11</TD><TD>ARC_TBS ... (9 Replies)
Discussion started by: ckwan
9 Replies
4. Shell Programming and Scripting
I need to take one column of data and put it into the following format:
1st line,2nd line
3rd line,4th line
5th line,6th line
...
Thanks! (6 Replies)
Discussion started by: batcho
6 Replies
5. Shell Programming and Scripting
Dear All,
I have input file like this.
input.txt
CE2_12-15 3950.00 589221.0 9849709.0 768.0 CE2_12_2012
CE2_12-15 3949.00 589199.0 9849721.0 768.0 CE2_12_2012
CE2_12-15 3948.00 589178.0 9849734.0 768.0 CE2_12_2012
CE2_12-52 1157.00 ... (3 Replies)
Discussion started by: attila
3 Replies
6. Shell Programming and Scripting
Hi
I have 5 columns like this
a b c d e
f g h i j
k l m n o
From 2nd column till the 5th column of every record, I would like to transpose them as rows, so my output file contains only one row
a
b
c
d
e
f
g
h
i
j (9 Replies)
Discussion started by: jacobs.smith
9 Replies
7. Shell Programming and Scripting
Hi,
I want to write a script which will add the entries in all columns for the same column id. I can do it in excel, but I need to do this for 384 columns which will come down to 96 (384/4). How can I do this iteratively
A A A A B B B B C C C C
1 0 1 0 2 1 4 5 3 4 5 6
2 0 0 2 3 5 70 100 1... (7 Replies)
Discussion started by: Diya123
7 Replies
8. Shell Programming and Scripting
HI Guys,
I want add one extra Column base on 3rd Column .
Input :-
M204 MS204_154 :vsDataUeMe
M204 MS204_154 es:sMeasure 0
M204 MS204_154 es:90ilterCoe 9
M204 MS204_154 es:searchE9090ortTime 40
M204 MS204_154 es:servOrPrioI90HoTimer 4000
M204 MS204_154 es:ueMeajllls154545 TRUE... (5 Replies)
Discussion started by: pareshkp
5 Replies
9. Linux
I have file that looks like this,
DIP-17571N|refseq:NP_651151 DIP-17460N|refseq:NP_511165|uniprotkb:P45890 DIP-17571N|refseq:NP_651151
DIP-19241N|refseq:NP_524261 DIP-19241N|refseq:NP_524261 DIP-17151N|refseq:NP_524316|uniprotkb:O16797
DIP-19588N|refseq:NP_731165 ... (2 Replies)
Discussion started by: Syeda Sumayya
2 Replies
10. UNIX for Beginners Questions & Answers
Input file is as follows:
1 | 6
2 | 7
3 | 8
4 | 9
5 | 10
Output reuired (sum of the first column $1*$2)
1 | 6 | 90
2 | 7 | 105
3 | 8 | 120
4 |9 | 135
5 |10 | 150
Please enclose sample input, sample output, and code... (5 Replies)
Discussion started by: Sagar Singh
5 Replies
NSIS(1) GenPat NSIS(1)
NAME
GenPat - A program to create patch files in VPatch format.
SYNOPSIS
GenPat [-R] [-B=64] [-V] [-O] [-A=500] [source] [target] [patch.pat]
DESCRIPTION
This manual page documents briefly the GenPat command.
This manual page was written for the Debian (TM) distribution because the original program does not have a manual page. Instead, it has
documentation in the HTML format; see below.
GenPat is a program that creates installer programs for Windows.
OPTIONS
-R
Replace a patch with same contents as source silently if it already exists.
-B=64
Set blocksize (default=64), multiple of 2 is required.
-V
More verbose information during patch creation.
-O
Deactivate match limit of the -A switch (sometimes smaller patches).
-A=500
Maximum number of block matches per block (improves performance). Default is 500, larger is slower. Use -V to see the cut-off aborts.
EXIT STATUS
0
Success
1
Arguments missing
2
Other error
3
Source file already has a patch in specified patch file (=error)
SEE ALSO
GenPat is documented more fully in the HTML file /usr/share/doc/nsis/Docs/VPatch/Readme.html.
AUTHOR
This manual page was written by Paul Wise pabs@debian.org for the Debian (TM) system.
AUTHOR
Paul Wise
Created man page
COPYRIGHT
Copyright (C) 2005 Paul Wise
GenPat manual October 5, 2005 NSIS(1)