merge rows based on a common column Post: 302247595

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

merge based on common, awk help

All, $ cat x.txt z 11 az x 12 ax y 13 ay $ cat y.txt ay TT ax NN Output required: y 13 ay TT x 12 ax NN

2. Shell Programming and Scripting

"Join" or "Merge" more than 2 files into single output based on common key (column)

Hi All, I have working (Perl) code to combine 2 input files into a single output file using the join function that works to a point, but has the following limitations: 1. I am restrained to 2 input files only. 2. Only the "matched" fields are written out to the "matched" output file and...

3. UNIX for Dummies Questions & Answers

Merge rows with common column

Dear all I have big file with two columns A_AA960715 GO:0006952 A_AA960715 GO:0008152 A_AA960715 GO:0016491 A_AA960715 GO:0007165 A_AA960715 GO:0005618 A_AA960716 GO:0006952 A_AA960716 GO:0005618 A_AA960716...

4. UNIX for Dummies Questions & Answers

Merge two files with common IDs but unequal number of rows

Hi, I have two files that I would like to merge and think that there should be a solution using awk. The files look something like this: file 1 IDX1 IDY1 IDX2 IDY2 IDX3 IDY3 file 2 IDY1 dataA data1 IDY2 dataB data2 IDY3 dataC data3 Desired output IDX1 IDY1 dataA data1 IDX2 ...

5. Shell Programming and Scripting

file merge based on common columns

I have two files 1.txt 34, ABC, 7, 8, 0.9 35, CDE, 6.5, -2, 0.01 2.txt 34, ABC, 9, 6, -1.9 35, CDE, 8.5, -2.3, 5.01 So in both files common columns are 1 and 2 so final o/p should look like 34, ABC, 7, 8, 0.9, 9, 6, -1.9 35, CDE, 6.5, -2, 0.01, 8.5, -2.3, 5.01 I tried using...

6. Shell Programming and Scripting

Count and merge using common column

I have the following records from multiple files. 415 A G 415 A G 415 A T 415 A . 415 A . 421 G A 421 G A,C 421 G A 421 G A 421 G A,C 421 G . 427 A C 427 A ...

7. Shell Programming and Scripting

Merge with common column

hi i have two files and i wanted to join them using common column. try to do this using "join" command but that did not help. File 1: 123 9a.vcf hy92.vcf hy90.vcf Index Ref Alt Ref Alt Ref Alt 315 14 0 7 4 ...

8. Shell Programming and Scripting

Merge files based on both common and uncommon rows

Hi, I have two files A (2190 rows) and file B (1100 rows). I want to merge the contents of two files based on common field, also I need the unmatched rows from file A file A: ABC XYZ PQR file B: >LMN|chr1:11000-12456: >ABC|chr15:176578-187678: >PQR|chr3:14567-15866: output...

9. Shell Programming and Scripting

Seperated by columns, merge in a file, sort them on common column

Hi All, I have 4 files in below format. I took them as an example. File 1: Cut from position 1-4 then 6-7 then 8-14 then rest left and make them as columns in one new file. Inserting character H to the initial of all line like HCTOT. CTOT 456787897 Low fever CTOR 556712345 High fever...

10. UNIX for Dummies Questions & Answers

Merge selective columns from files based on common key

Hi, I am trying to selectively merge two files based on keys reported in the 1st column. File1: #file1-header1 file1-header2 111 qwe rtz uio 198 asd fgh jkl 165 yxc 789 poi uzt rew 89 lkj File2: #file2-header2 file2-header2 165 ghz nko2 ...

LEARN ABOUT CENTOS

column

COLUMN(1)							   User Commands							 COLUMN(1)

NAME

       column - columnate lists

SYNOPSIS

       column [options] file...

DESCRIPTION

       The column utility formats its input into multiple columns.  Rows are filled before columns.  Input is taken from file or, by default, from
       standard input.	Empty lines are ignored.

OPTIONS

       -c, --columns width
	      Output is formatted to a width specified as number of characters.

       -t, --table
	      Determine the number of columns the input contains and create a table.  Columns are delimited with whitespace, by default,  or  with
	      the characters supplied using the separator. Table output is useful for pretty-printing.

       -s, --separator separators
	      Specify possible table delimiters (default is whitespace).

       -o, --output-separator separators
	      Specify table output delimiter (default is two whitespaces).

       -x, --fillrows
	      Fill columns before filling rows.

       -h, --help
	      Print help and exit.

ENVIRONMENT

       The environment variable COLUMNS is used to determine the size of the screen if no other information is available.

EXAMPLES

       sed 's/#.*//' /etc/fstab | column -t

BUGS

       The util-linux version 2.23 changed -s option to be non-greedy, for example:

       $ printf "a:b:c
1::3
" | column  -t -s ':'

       old output:
       a  b  c
       1  3

       new output (since util-linux 2.23)
       a  b  c
       1     3

SEE ALSO

       colrm(1), ls(1), paste(1), sort(1)

HISTORY

       The column command appeared in 4.3BSD-Reno.

AVAILABILITY

       The column command is part of the util-linux package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux/.

util-linux							   October 2010 							 COLUMN(1)