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

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with complex merg of files with common field

Please help, I am new to shell Programming. I have three files each containg a unique text (key) field (e.g. ABCDEF, XCDUD as shown below), line return followed by some data of which there can be more then one instance. In addition, in some cases there may be no data but only a key field. Please...

2. Shell Programming and Scripting

How to append two files with common field.

I have two files like File1 : will get this file from "who" command. It is a unix file. user val1 Jul 29 13:15 (IP Address1) user val3 Jul 30 03:21 (IP Address2) user val2 Jul 29 13:16 (IP Address3) user val4 Jul 29 13:17 (IP Address4) ...

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

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

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

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

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

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

10. UNIX for Beginners Questions & Answers

Awk: output lines with common field to separate files

Hi, A beginner one. my input.tab (tab-separated): h1 h2 h3 h4 h5 item1 grpA 2 3 customer1 item2 grpB 4 6 customer1 item3 grpA 5 9 customer1 item4 grpA 0 0 customer2 item5 grpA 9 1 customer2 objective: output a file for each customer ($5) with the item number ($1) only if $2 matches...

LEARN ABOUT DEBIAN

www::search::altavista::advancednews

WWW::Search::AltaVista::AdvancedNews(3pm)		User Contributed Perl Documentation		 WWW::Search::AltaVista::AdvancedNews(3pm)

NAME

       WWW::Search::AltaVista::AdvancedNews - class for advanced Alta Vista news searching

SYNOPSIS

	   use WWW::Search;
	   my $oSearch = new WWW::Search('AltaVista::AdvancedNews');

DESCRIPTION

       This class implements the advanced AltaVista news search (specializing AltaVista and WWW::Search).  It handles making and interpreting
       AltaVista web searches http://www.altavista.com.

       Details of AltaVista can be found at WWW::Search::AltaVista.

       This class exports no public interface; all interaction should be done through WWW::Search objects.

AUTHOR

       "WWW::Search" is written by John Heidemann, <johnh@isi.edu>.

COPYRIGHT

       Copyright (c) 1996 University of Southern California.  All rights reserved.

       Redistribution and use in source and binary forms are permitted provided that the above copyright notice and this paragraph are duplicated
       in all such forms and that any documentation, advertising materials, and other materials related to such distribution and use acknowledge
       that the software was developed by the University of Southern California, Information Sciences Institute.  The name of the University may
       not be used to endorse or promote products derived from this software without specific prior written permission.

       THIS SOFTWARE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
       MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.

   native_setup_search
       This private method does the heavy lifting after native_query() is called.

perl v5.12.4							    2011-11-02				 WWW::Search::AltaVista::AdvancedNews(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with complex merg of files with common field

Discussion started by: gugs

2. Shell Programming and Scripting

How to append two files with common field.

Discussion started by: manneni prakash

3. Shell Programming and Scripting

merge two text files of different size on common index

Discussion started by: LMHmedchem

4. Shell Programming and Scripting

join files based on a common field

Discussion started by: GoldenFire