Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Join two files with common and range identifiers
Top Forums Shell Programming and Scripting Join two files with common and range identifiers Post 302675801 by cfiles2012 on Monday 23rd of July 2012 03:27:39 PM
Old 07-23-2012
sample files
Here are two sample files

abc.txt

name fff1 ppp1
sam 1 12
pam 1 14
jen 2 8
trout 2 6
pat 3 12
don 3 16


xyz.txt

id fff1 qqq1 rrr1
234 1 10 15
456 2 4 7
324 2 8 10
334 3 10 20

The resulting file should be abcxyz.txt

name fff1 ppp1 id qqq1 rrrr1
sam 1 12 234 10 15
pam 1 14 234 10 15
jen 2 8 324 8 10
trout 2 6 456 4 7
pat 3 12 334 10 20
don 3 16 334 10 20
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

List of common identifiers

Hi all, I have 4 file and I want to find the common identifier in each file. For example: FILE1 goat door bear cat FILE2 goat moose dog cat FILE3 goat yak tiger (6 Replies)
Discussion started by: phil_heath
6 Replies

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... (1 Reply)
Discussion started by: Katabatic
1 Replies

3. Shell Programming and Scripting

Join multiple files based on 1 common column

I have n files (for ex:64 files) with one similar column. Is it possible to combine them all based on that column ? file1 ax100 20 30 40 ax200 22 33 44 file2 ax100 10 20 40 ax200 12 13 44 file2 ax100 0 0 4 ax200 2 3 4 (9 Replies)
Discussion started by: quincyjones
9 Replies

4. Web Development

Perl join two files by "common" column

Hello; I am posting to get any help on my code that I have been struggling for some time. The project is to join two files each with 80k~180k rows. I want to merge them together by the shared common column. The problem of the shared column is partially matching, not exactly the same. File1:... (5 Replies)
Discussion started by: yifangt
5 Replies

5. Shell Programming and Scripting

join files based on a common field

Hi experts, Would you please help me with this? I have several files and I need to join the forth field of them based on the common first field. here's an example... first file: 280346 39.88 -75.08 547.8 280690 39.23 -74.83 538.7 280729 40.83 -75.08 499.2 280907 40.9 -74.4 507.8... (5 Replies)
Discussion started by: GoldenFire
5 Replies

6. UNIX for Dummies Questions & Answers

how to join two files using "Join" command with one common field in this problem?

file1: Toronto:12439755:1076359:July 1, 1867:6 Quebec City:7560592:1542056:July 1, 1867:5 Halifax:938134:55284:July 1, 1867:4 Fredericton:751400:72908:July 1, 1867:3 Winnipeg:1170300:647797:July 15, 1870:7 Victoria:4168123:944735:July 20, 1871:10 Charlottetown:137900:5660:July 1, 1873:2... (2 Replies)
Discussion started by: mindfreak
2 Replies

7. UNIX for Dummies Questions & Answers

How to use the the join command to join multiple files by a common column

Hi, I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column). I want to write a script to join the files by the first common column so that in the... (5 Replies)
Discussion started by: evelibertine
5 Replies

8. UNIX for Dummies Questions & Answers

How to join 2 .txt files based on a common column?

Hi all, I'm trying to join two .txt file tab delimitated based on a common column. File 1 transcript_id gene_id length effective_length expected_count TPM FPKM IsoPct comp1000201_c0_seq1 comp1000201_c0 337 183.51 0.00 0.00 0.00 0.00 comp1000297_c0_seq1 ... (1 Reply)
Discussion started by: alisrpp
1 Replies

9. 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

10. Shell Programming and Scripting

Linux - Join 2 csv files with common key

Hi, I am trying to join 2 csv files, to create a 3rd output file with the joined data. Below is an example of my Input Data: Input File 1 NAME, FAV_FOOD, FAV_DRINK, ID, GENDER Bob, Fish, Coke, 1, M Lisa, Rice, Water, 2, F Jenny, Noodle, Tea, 3, F Ken, Pizza, Coffee, 4, M Lisa,... (7 Replies)
Discussion started by: RichZR
7 Replies

LEARN ABOUT SUNOS

iconv_1250

iconv_1250(5)						Standards, Environments, and Macros					     iconv_1250(5)

NAME

       iconv_1250 - code set conversion tables for MS 1250 (Windows Latin 2)

DESCRIPTION

       The following code set conversions are supported:

       +----------------------------------------------------------------------+
       |		   Code Set Conversions Supported		      |
       +-------------+----------+--------------+----------+-------------------+
       |    Code     |	Symbol	| Target Code  | Symbol   |  Target Output    |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2	| ISO 8859-2   |iso2	  |ISO Latin 2	      |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2	| MS 852       |dos2	  |MS-DOS Latin 2     |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2	| Mazovia      |maz	  |Mazovia	      |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2	| DHN	       |dhn	  |Dom Handlowy Nauki |
       +-------------+----------+--------------+----------+-------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   MS 1250 to ISO 8859-2
       For the conversion of MS 1250 to ISO 8859-2, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1250     |  ISO 8859-2	|   MS 1250	 |  ISO 8859-2	 |
       |24-211	       | 40		|235		 |273		 |
       |212	       | 251		|236		 |276		 |
       |213	       | 40		|237		 |274		 |
       |214	       | 246		|241		 |267		 |
       |215	       | 253		|245		 |241		 |
       |216	       | 256		|246-267	 |40		 |
       |217	       | 254		|271		 |261		 |
       |221-231        | 40		|273		 |40		 |
       |232	       | 271		|274		 |245		 |
       |233	       | 40		|276		 |265		 |
       |234	       | 266		|247		 |365		 |
       +---------------+----------------+----------------+---------------+

   MS 1250 to MS 852
       For the conversion of MS 1250 to MS 852, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1250     |    MS 852	|   MS 1250	 |    MS 852	 |
       |200-211        | 40		|311		 |220		 |
       |212	       | 346		|312		 |250		 |
       |213	       | 40		|313		 |323		 |
       |214	       | 227		|314		 |267		 |
       |215	       | 233		|315		 |326		 |
       |216	       | 246		|316		 |327		 |
       |217	       | 215		|317		 |322		 |
       |220-231        | 40		|320		 |321		 |
       |232	       | 347		|321		 |343		 |
       |233	       | 40		|322		 |325		 |
       |234	       | 230		|323		 |340		 |
       |235	       | 234		|324		 |342		 |
       |236	       | 247		|325		 |212		 |
       |237	       | 253		|326		 |231		 |
       |240	       | 377		|327		 |236		 |
       |241	       | 363		|330		 |374		 |
       |242	       | 364		|331		 |336		 |
       |243	       | 235		|332		 |351		 |
       |244	       | 317		|333		 |353		 |
       |245	       | 244		|334		 |232		 |
       |246	       | 40		|335		 |355		 |
       |247	       | 365		|336		 |335		 |
       |250	       | 371		|337		 |341		 |
       |251	       | 40		|340		 |352		 |
       |252	       | 270		|341		 |240		 |
       |253	       | 256		|342		 |203		 |
       |254	       | 252		|343		 |307		 |
       |255	       | 360		|344		 |204		 |
       |256	       | 40		|345		 |222		 |
       |257	       | 275		|346		 |206		 |
       |260	       | 370		|347		 |207		 |
       |261	       | 40		|350		 |237		 |
       |262	       | 362		|351		 |202		 |
       |263	       | 210		|352		 |251		 |
       |264	       | 357		|353		 |211		 |
       |265-267        | 40		|354		 |330		 |
       |270	       | 367		|355		 |241		 |
       |271	       | 245		|356		 |214		 |
       |272	       | 255		|357		 |324		 |
       |273	       | 257		|360		 |320		 |
       |274	       | 225		|361		 |344		 |
       |275	       | 361		|362		 |345		 |
       |276	       | 226		|363		 |242		 |
       |277	       | 276		|364		 |223		 |
       |300	       | 350		|365		 |213		 |
       |301	       | 265		|366		 |224		 |
       |302	       | 266		|367		 |366		 |
       |303	       | 306		|370		 |375		 |
       |304	       | 216		|371		 |205		 |
       |305	       | 221		|372		 |243		 |
       |306	       | 217		|374		 |201		 |
       |307	       | 200		|375		 |354		 |
       |310	       | 254		|376		 |356		 |
       +---------------+----------------+----------------+---------------+

   MS 1250 to Mazovia
       For the conversion of MS 1250 to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1250     |    Mazovia	|   MS 1250	 |   Mazovia	 |
       |200-213        | 40		|310-311	 |40		 |
       |214	       | 230		|312		 |220		 |
       |215-216        | 40		|313-320	 |40		 |
       |217	       | 240		|321		 |245		 |
       |220-233        | 40		|322		 |40		 |
       |234	       | 236		|323		 |243		 |
       |235-236        | 40		|324-325	 |40		 |
       |237	       | 246		|326		 |231		 |
       |240	       | 377		|327-333	 |40		 |
       |241-242        | 40		|334		 |232		 |
       |243	       | 234		|335-336	 |40		 |
       |244	       | 40		|337		 |341		 |
       |245	       | 217		|340-341	 |40		 |
       |246-252        | 40		|342		 |203		 |
       |253	       | 256		|343		 |40		 |
       |254	       | 252		|344		 |204		 |
       |255-256        | 40		|345		 |40		 |
       |257	       | 241		|346		 |215		 |
       |260	       | 370		|347		 |207		 |
       |261	       | 361		|350		 |40		 |
       |262	       | 40		|351		 |202		 |
       |263	       | 222		|352		 |221		 |
       |264	       | 40		|353		 |211		 |
       |265	       | 346		|354-355	 |40		 |
       |266	       | 40		|356		 |214		 |
       |267	       | 372		|357-360	 |40		 |
       |270	       | 40		|361		 |244		 |
       |271	       | 206		|362		 |40		 |
       |272	       | 40		|363		 |242		 |
       |273	       | 257		|364		 |223		 |
       |274-276        | 40		|365		 |40		 |
       |277	       | 247		|366		 |224		 |
       |300-303        | 40		|367		 |366		 |
       |304	       | 216		|370-373	 |40		 |
       |305	       | 40		|374		 |201		 |
       |306	       | 225		|375-376	 |40		 |
       |307	       | 200		|		 |		 |
       +---------------+----------------+----------------+---------------+

   MS 1250 to DHN
       For the conversion of MS 1250 to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |   MS 1250     |      DHN	|   MS 1250	 |     DHN	 |
       |200-213        | 40		|306		 |201		 |
       |214	       | 206		|307-311	 |40		 |
       |215-216        | 40		|312		 |202		 |
       |217	       | 207		|313-320	 |40		 |
       |220-233        | 40		|321		 |204		 |
       |234	       | 217		|322		 |40		 |
       |235-236        | 40		|323		 |205		 |
       |237	       | 220		|324-325	 |40		 |
       |240	       | 377		|326		 |231		 |
       |241-242        | 40		|327-333	 |40		 |
       |243	       | 203		|334		 |232		 |
       |244	       | 40		|335-336	 |40		 |
       |245	       | 200		|337		 |341		 |
       |246-252        | 40		|340		 |40		 |
       |253	       | 256		|341		 |240		 |
       |254	       | 252		|342-345	 |40		 |
       |255-256        | 40		|346		 |212		 |
       |257	       | 210		|347-351	 |40		 |
       |260	       | 370		|352		 |213		 |
       |261	       | 361		|353-354	 |40		 |
       |262	       | 40		|355		 |241		 |
       |263	       | 214		|356-360	 |40		 |
       |264	       | 40		|361		 |215		 |
       |265	       | 346		|362		 |40		 |
       |266	       | 40		|363		 |216		 |
       |267	       | 372		|364		 |223		 |
       |270	       | 40		|365		 |40		 |
       |271	       | 211		|366		 |224		 |
       |272	       | 40		|367		 |366		 |
       |273	       | 257		|370-371	 |40		 |
       |274-276        | 40		|372		 |243		 |
       |277	       | 221		|373-376	 |40		 |
       |300-305        | 40		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						     iconv_1250(5)
All times are GMT -4. The time now is 11:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy