Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Merge two files with common IDs but unequal number of rows
Top Forums UNIX for Dummies Questions & Answers Merge two files with common IDs but unequal number of rows Post 302605496 by Scrutinizer on Wednesday 7th of March 2012 02:31:42 PM
Old 03-07-2012
OK, now I think I understand what you mean (I thought you meant the other way around)
Try:
Code:
awk 'NR==FNR{A[$2]=$0;next}$1=A[$1]' file1 file2

Last edited by Scrutinizer; 03-07-2012 at 04:22 PM..
This User Gave Thanks to Scrutinizer For This Post:
katie8856
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

merge rows based on a common column

Hi guys, Please guide me if you have a solution to this problem. I have tried paste -s but it's not giving the desired output. I have a file with the following content- A123 box1 B345 bat2 C431 my_id A123 service C431 box1 A123 my_id I need two different outputs- OUTPUT1 A123... (6 Replies)
Discussion started by: smriti_shridhar
6 Replies

2. Shell Programming and Scripting

Merge files of differrent size with one field common in both files using awk

hi, i am facing a problem in merging two files using awk, the problem is as stated below, file1: A|B|C|D|E|F|G|H|I|1 M|N|O|P|Q|R|S|T|U|2 AA|BB|CC|DD|EE|FF|GG|HH|II|1 .... .... .... file2 : 1|Mn|op|qr (2 Replies)
Discussion started by: shashi1982
2 Replies

3. Shell Programming and Scripting

merge two text files of different size on common index

I have two text files. text file 1: ID filePath col1 col2 col3 1 10584588.mol 269.126 190.958 23.237 2 10584549.mol 281.001 200.889 27.7414 3 10584511.mol 408.824 158.316 29.8561 4 10584499.mol 245.632 153.241 25.2815 5 10584459.mol ... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

4. UNIX for Dummies Questions & Answers

Writing a loop to merge multiple files by common column

I have 100 data files labelled 250.1.txt through 250.100.txt. The second column of the data files partially match (there is about %90 overlap). Each data file has 4 columns. I want the merge all these text files by the matching values in the second column. In the output, the first column should... (1 Reply)
Discussion started by: evelibertine
1 Replies

5. UNIX for Advanced & Expert Users

merge two tab delimited file with exact same number of rows in unix/linux

Hi I have two tab delimited file with different number of columns but same number of rows. I need to combine these two files in such a way that row 1 in file 2 comes adjacent to row 1 in file 1. For example: The content of file1: field1 field2 field3 a1 a2 a3 b1 b2 b3... (2 Replies)
Discussion started by: mary271
2 Replies

6. 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... (15 Replies)
Discussion started by: AAWT
15 Replies

7. Shell Programming and Scripting

Merging files with common IDs without JOIN

Hi, I am trying to merge information across 2 files. The first file is a "master" file, with all IDS. File 2 contains a subset of IDs of those in File 1. I would like to match up individuals in File 1 and File 2, and add information in File 2 to that of File 1 if they appear. However, if an... (3 Replies)
Discussion started by: hubleo
3 Replies

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... (3 Replies)
Discussion started by: Diya123
3 Replies

9. Shell Programming and Scripting

Merge multiple files with common header

Hi all, Say i have multiple files x1 x2 x3 x4, all with common header (date, time, year, age),, How can I merge them to one singe file "X" in shell scripting Thanks for your suggestions. (2 Replies)
Discussion started by: msarguru
2 Replies

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 ... (2 Replies)
Discussion started by: dovah
2 Replies

LEARN ABOUT SUSE

intltool-merge

INTLTOOL-MERGE(8)					      System Manager's Manual						 INTLTOOL-MERGE(8)

NAME

       intltool-merge - merge translated strings into various types of file

SYNOPSIS

       intltool-merge [option]... PO_DIRECTORY FILENAME OUTPUT_FILE

DESCRIPTION

       Merge  translated strings in po files in PO_DIRECTORY with the original application file FILENAME, and output the file OUTPUT_FILE contain-
       ing both original and localized strings.

       If FILENAME is an XML file, OUTPUT_FILE will contain repeated xml nodes, where each  node  contains  one  of  the  localized  strings  with
       "xml:lang" attribute.

OPTIONS

   Mode of operation
       -b
       --ba-style
	   Merge files in bonobo-activation style, which is used for bonobo servers.

       -d
       --desktop-style
	   Merge files in desktop style, which is similar to the Windows .ini file format.

       -k
       --keys-style
	   Merge files in keys style, which is used for metadata.

       -o
       --oaf-style
	   (OBSOLETE) Same as -b/--ba-style.

       -r
       --rfc822deb-style
	   Merge files in RFC 822 style, which is usually used in Debian configuration files.

       --quoted-style
	   Merge files in quoted string style, which just translates any strings within "".

       -x
       --xml-style
	   Merge files in standard XML style, both as attributes and as raw pcdata.

   Other options
       -u
       --utf8
	   Convert all strings to UTF-8 before merging.

       -p
       --pass-through
	   Use strings as is in .po files without conversion (STRONGLY unrecommended with -x).

       -c
       --cache
	   (TBD)

       -q
       --quiet
	   Be quiet while running.

       -v
       --version
	   Show version information.

       -h
       --help
	   Show usage and basic help information.

FILES

       po/.intltool-merge-cache
	      Cache file generated by intltool-merge, that contains all strings in all po files separated by 1.

REPORTING BUGS

       Report bugs to http://bugs.launchpad.net/intltool

AUTHOR

       Darin Adler <darin@bentspoon.com>
       Kenneth Christiansen <kenneth@gnu.org>
       Maciej Stachowiak <mjs@eazel.com>

SEE ALSO

       iconv(1), intltoolize(8), intltool-prepare(8), intltool-extract(8), intltool-update(8)

intltool							    2003-08-02							 INTLTOOL-MERGE(8)
All times are GMT -4. The time now is 05:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy