Sponsored Content
Top Forums Shell Programming and Scripting Merging 2 files based on a common column Post 302480350 by cabrao on Tuesday 14th of December 2010 03:38:27 PM
Old 12-14-2010
Someone asked the same question today...

Have a look here: https://www.unix.com/shell-programmin...on-column.html
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging two files with a common column

Hi, I have two files file1 and file2. I have to merge the columns of those two files into file3 based on common column of two files. To be simple. file1: Row-id name1 13456 Rahul 16789 Vishal 18901 Karan file2 : Row-id place 18901 Mumbai ... (2 Replies)
Discussion started by: manneni prakash
2 Replies

2. Shell Programming and Scripting

merging column from two files based on identifier

Hi, I have two files consisting of two columns. So I want to merge column 2 if column 1 is the same. So heres an example of what I mean. FILE1 driver 444 car 333 hat 222 FILE2 driver 333 car 666 hat 999 So I want to merge the column 2's together so... (4 Replies)
Discussion started by: phil_heath
4 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. Shell Programming and Scripting

merging two files based on first column

I had two files file1 and file2. I want a o/p file(file3) like below using first column as ref. Pls give suggestion ass join is not working as the number of lines in each file is nealry 5 C? file1 --------------------- 404000324810001 Y 404000324810004 N 404000324810008 Y 404000324810009 N... (1 Reply)
Discussion started by: p_sai_ias
1 Replies

5. Shell Programming and Scripting

Merging CSV fields based on a common field

Hi List, I have two files. File1 contains all of the data I require to be processed, and I need to add another field to this data by matching a common field in File2 and appending a corresponding field to the data in File1 based on the match... So: File 1:... (1 Reply)
Discussion started by: landossa
1 Replies

6. Shell Programming and Scripting

Merging columns based on one or more column in two files

I have two files. FileA.txt 30910 rs7468327 36587 rs10814410 91857 rs9408752 105797 rs1133715 146659 rs2262038 152695 rs2810979 181843 rs3008128 182129 rs3008131 192118 rs3008170 FileB.txt 30910 1.9415219673 0 36431 1.3351312477 0.0107191428 36587 1.3169171182... (2 Replies)
Discussion started by: genehunter
2 Replies

7. Shell Programming and Scripting

common entries between files based on 1st column

Hi, I am trying to get the common entries from 2 files based on 1st field.. However when I try to do in perl I am getting blank output.. How can I do this in awk? open(BUFF1, "my_genes"); open(BUFF3, "rawcounts"); #open(WRBUFF,">result_rawcounts"); while($line =<BUFF1>) { ... (3 Replies)
Discussion started by: Diya123
3 Replies

8. Shell Programming and Scripting

Merging 2 text files when there is a common time stamp column in them

Dear Unix experts and users I have 2 kinds of files like below, of which I need to merge them in the order of time. File1: Date_Time Context D1 D2 04/19/2013_23:48:54.819 ABCD x x 04/19/2013_23:48:55.307 ABCD x x 04/19/2013_23:48:55.823 ABCD x ... (7 Replies)
Discussion started by: ks_reddy
7 Replies

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

10. Shell Programming and Scripting

Paste columns based on common column: multiple files

Hi all, I've multiple files. In this case 5. Space separated columns. Each file has 12 columns. Each file has 300-400K lines. I want to get the output such that if a value in column 2 is present in all the files then get all the columns of that value and print it side by side. Desired output... (15 Replies)
Discussion started by: genome
15 Replies
Template::Plugin::Clickable(3pm)			User Contributed Perl Documentation			  Template::Plugin::Clickable(3pm)

NAME
Template::Plugin::Clickable - Make URLs clickable in HTML SYNOPSIS
[% USE Clickable %] [% FILTER clickable %] URL is http://www.tt2.org/ [% END %] this will become: URL is <a href="http://www.tt2.org/">http://www.tt2.org/</a> DESCRIPTION
Template::Plugin::Clickable is a plugin for TT, which allows you to filter HTMLs clickable. OPTIONS
target [% FILTER clickable target => '_blank' %] [% message.body | html %] [% END %] "target" option enables you to set target attribute in A links. none by default. finder_class "finder_class" option enables you to set other URI finder class rather than URI::Find (default). For example, [% FILTER clickable finder_class => 'URI::Find::Schemeless' %] Visit www.example.com/join right now! [% END %] this will become: Visit <a href="http://www.example.com/join">www.example.com/join</a> right now! NOTE
If you use this module with "html" filter, you should be careful not to break tags or brackets around the URLs. For example if you have a following URL form, <http://www.example.com/> Clickable plugin will filter this into: <a href="http://www.example.com/"><http://www.example.com/></a> which is bad for HTML viewing. However, if you HTML filter them first and then clickable filter, you'll get: &lt;<a href="http://www.example.com/&gt">http://www.example.com/&gt</a>; which href part is wrong. You'd better try Template::Plugin::TagRescue in this case. [% USE Clickable -%] [% USE TagRescue -%] [% FILTER html_except_for('a') -%] [% FILTER clickable -%] <http://www.example.com/> [%- END %] [%- END %] will give you the right format. AUTHOR
Tatsuhiko Miyagawa <miyagawa@bulknews.net> This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
Template, URI::Find, Template::Plugin::TagRescue perl v5.8.8 2006-11-23 Template::Plugin::Clickable(3pm)
All times are GMT -4. The time now is 12:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy