Hi guys,

I face the problem of joining several tab delimited files into one table, which is certainly possible to do by a lot of clicking in excel, but when the number of those files is close to a hundred it becomes a real pain. Here are the details:

Our files: file_1, file_2, ..., file_n contain only two columns as follows:

A 12

B 152

C 123

D 456

First column contains "categories" and it stays the same in every file, second contains some numeric values. I would like to create a table, where the first column is "categories" and the rest are second columns from every file with headers corresponding to file names. Is there an easy way to do something like that in perl? I'm have only beginner skills and whatever I was trying to hack together doesn't work.

Alternatively, I could use paste command from shell, but its doesn't work the way I want.

Thanks a lot in advance!

In reply to simple table join script by slavailn

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.