My apologies about the previous submit. Hit the create button mistakenly. It is formatted better now.

Thank you Anonymous Monk. The column numbers vary by file. I have below a perl script where I first split the file using awk in bash then try to merge each file to a file with the row names. There is also another file that I used that split the file on tab across each row then place the first element of array in a scalar variable. Then I tried adding the first element and the remaining elements to a hash

The first code 

 #!/usr/bin/perl -w
use strict;        
use warnings;
use diagnostics;
use Getopt::Std;

#reading options
our ($opt_i);
getopts('i:');
if (!$opt_i) {
    print STDERR "\nInput file name (-i) required\n\n\n";
}
#open the file or die
open INFILE, "<", $opt_i or die "No such input file $opt_i";

while (<INFILE>) {
chomp;
my @fh = <INFILE>;

my @fh = split ('\t', $_);
#print "@fh";
    my $geno = shift @fh;
    
    
#open directory. the "." represents current directory
opendir(DIR, ".");

#place all files in an array
#@files = readdir(DIR);
    my @files = glob("*.txt");

#close directory
closedir(DIR);
my @merge;

#process each file
    foreach my $file (@files) {
    open FILE, "<", $file;
    
    while(my @line = <FILE>) {
        foreach my $comb (@line) {

        print "$geno\t"."$comb";
    close FILE;
     
    }
        
}
}
}
close INFILE;

[download]

The second code, which is splitting the file

 #!/usr/bin/perl -w

use strict;            
use warnings;
use diagnostics;
use Getopt::Std;

#reading options
our ($opt_i);
getopts('i:');
if (!$opt_i) {
    print STDERR "\nInput file name (-i) required\n\n\n";
}
#open the file or die
open INFILE, "<", $opt_i or die "No such input file $opt_i";

my %file;
while (<INFILE>) {
#remove the newline character
chomp;

#create an array
my @fh = <INFILE>;

#split the file by tabs in each row
@fh = split ('\t', $_);
#place the first column (row names) in $geno
    my $geno = shift @fh;

  my $remain = join "_", @fh[1-];
    push @{$geno{$remain}}, $_;
}
# print the first field (the username)
 print "%file\n";
}
close INFILE;

[download]

In reply to Re^3: Split a large text file by columns by tc
in thread Split a large text file by columns by tc

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.