07-29-2011
AWK: combining consecutive values in a field
Hi,
Here is my sample input
X 2 AAA |
Y 3 BBB |
Y 2 CCC |
Z 4 DDD |
In field 1, if the value of one line is same as that of next line, I want to concatenate the corresponding value of the second line in the third field with the value of the third field of first line. And I dont need the third line in the out put. phew!
Needed Output
X 2 AAA |
Y 3 BBB_CCC |
Z 4 DDD |
I am a biologist and have no Idea regarding awk scripting. So please dont ask me what I have tried
Thank you very much in advance.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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)
Discussion started by: Kirichiko
3 Replies
2. Shell Programming and Scripting
Hi,
I have a file like this
A Bob
A Sam
A John
B David
C Paul
C Sandra
If the consecutive field values in column one is same, then concatenate the corresponding strings.
So, I need an output like this,
A Bob_Sam_John
B David
C Paul_Sandra
I usually work with excel but... (3 Replies)
Discussion started by: polsum
3 Replies
3. Shell Programming and Scripting
I would like to compare the values of 2nd column of consecutive lines of same file in such a way so that if the difference between first value and second value is more than 100 it should print complete line else ignore line.
Input File
==========
PDB 2500
RTDB 123
RTDB-EAGLE 122
VSCCP 2565... (4 Replies)
Discussion started by: manuswami
4 Replies
4. Shell Programming and Scripting
Hi,
I am using UBUNTU 12.04.
I have a dataset as follows:
Column#1 Column#2 Column#3 .... Column#50
1 154878
1 145145
2 189565
2 454121
... (5 Replies)
Discussion started by: Homa
5 Replies
5. Shell Programming and Scripting
Hello there,
I have a file with few fields separated by ":". I wrote a below awk to manipulate this file:
awk 'BEGIN { FS=OFS=":" }\
NR != 1 && $2 !~ /^98/ && $8 !~ /^6/{print $0}' $in_file > $out_file
What I wanted was that if $8 field contains any of the values - 6100, 6110, 6200 -... (2 Replies)
Discussion started by: juzz4fun
2 Replies
6. UNIX for Dummies Questions & Answers
Hi all !
I almost did it but got a small problem.
input:
cars red
cars blue
cars green
truck black
Wanted:
cars red-blue-green
truck black
Attempt:
gawk 'BEGIN{FS="\t"}{a = a (a?"-":"")$2; $2=a; print $1 FS $2}' input
But I also got the intermediate records... (2 Replies)
Discussion started by: beca123456
2 Replies
7. Shell Programming and Scripting
I have a file in below format:
file01.txt
TERM
TERM
TERM
ABC 12315 68.53 12042013 165144
ABC 12315 62.12 12042013 165145
ABC 12315 122.36 12052013 165146
ABC 12315 582.18 12052013 165147
ABC 12316 2.36 12052013 165141
ABC 12316 ... (8 Replies)
Discussion started by: alex2005
8 Replies
8. UNIX for Dummies Questions & Answers
Input:
A|1
B|2
C|3
D|4
Output:
A+B|3
A+C|4
A+D|5
B+C|5
B+D|6
C+D|7
A+B+C|6
A+B+D|7
A+C+D|8
B+C+D|9
A+B+C+D|10
I only managed to get the output for pairs of $1 values (i.e. combination of length 2): (4 Replies)
Discussion started by: beca123456
4 Replies
9. Shell Programming and Scripting
Hi Friends,
Below is my input file with "|" (pipe) as filed delimiter:
My Input File:
HDR|F1|F2||||F6|F7
I want to inser values in the record for field 4 and field 5.
Expected output
HDR|F1|F2||F4|F5|F6|F7
I am able to append the string to the end of the record, but not in between the... (3 Replies)
Discussion started by: Ajay Venkatesan
3 Replies
10. UNIX for Beginners Questions & Answers
I have some data that looks like this:
PXD= ZW< 1,6
QR> QRJ== 1,2(5)
QR> QRJ== 4,1(2)
QR> QRJ== 4,2
QRB= QRB 4,2
QWM QWM 6,2
R<C ZW< 11,2
R<H= R<J= 6,1
R>H XZJ= 1,2(2)
R>H XZJ= 2,6(2)
R>H XZJ= 4,1(2)
R>H XZJ= 6,2
RDP RDP 1,2
What I would like to do is if fields $1 and $2 are... (5 Replies)
Discussion started by: jvoot
5 Replies
LEARN ABOUT DEBIAN
dbs_dumptabdata
DBS_DUMPTABDATA(1p) User Contributed Perl Documentation DBS_DUMPTABDATA(1p)
NAME
dbs_dumptabdata - Creates file set with SQL table data
DESCRIPTION
dbs_dumptabdata is an utility to create a file set with SQL table data. For each table in the database dbs_dumptabdata calls the appropri-
ate dumper utility with the output directed to a file named table.sql in the current directory. dbs_dumptabdata asks for a password if nec-
essary.
COMMAND LINE PARAMETERS
Required command line parameters are the DBI driver ("Pg" for Postgres or "mysql" for MySQL) and the database name. The third parameter is
optionally and specifies the database user and/or the host where the database resides ("racke", "racke@linuxia.de" or "@linuxia.de").
COMMAND LINE OPTIONS
-t TABLE[,TABLE,...], --tables=TABLE[,TABLE,...]
Comma-separated list of tables to dump.
--exclude-matching-tables=REGEXP
Excludes any table matching the regular expression REGEXP from dumping.
--use-printtab
Uses generic dump (similar to "dbs_printtab") instead of the dumper utility provided by the DBMS.
BUGS
msql is not supported.
AUTHOR
Stefan Hornburg (Racke), racke@linuxia.de
SEE ALSO
perl(1), DBIx::Easy(3)
perl v5.8.8 2007-02-01 DBS_DUMPTABDATA(1p)