Re: Searching and Coutning using 2 files with multiple columns

#!/usr/bin/perl -lan
BEGIN {
    die "Usage: $0 Boundary.out DB.out"
        unless @ARGV == 2;
}

if ( $isDB ) {
    print $_, "\t" . grep { $_->[0] > $F[2] && $_->[1] < $F[3] }
                        @{$chr{$F[1]}}
}
else {
    push @{$chr{$F[0]}}, [ @F[1, 2] ];
    $isDB = eof;
}

[download]

Replies are listed 'Best First'.
Re^2: Searching and Coutning using 2 files with multiple columns by shart3 (Novice) on Sep 16, 2009 at 17:54 UTC
ccn, Thanks! This seems to work for the most part (even though I don't understand any of it). However, it is replacing the chr# with the count number. For example if the value is 2, I get `Xkr4 2hr1 3204562 3661779 - 3 457.217` [download] or of the number is larger (say 12): `Xkr4 12r1 3204562 3661779 - 3 457.217` [download] I would like it to be: `Xkr4 chr1 3204562 3661779 - 3 457.217 2 or Xkr4 chr1 3204562 3661779 - 3 457.217 12` [download]	[reply] [d/l] [select]
Re^3: Searching and Coutning using 2 files with multiple columns by ccn (Vicar) on Sep 16, 2009 at 18:51 UTC
Hmm... It works for me as desired on your sample data. What delimiters do you use between columns? What is your OS? Please try this one: `#!/usr/bin/perl -lan BEGIN { die "Usage: $0 Boundary.out DB.out" unless @ARGV == 2; } if ( $isDB ) { print join "\t", @F, ~~grep { $_->[0] > $F[2] && $_->[1] < $F[3] } @{$chr{$F[1]}} } else { push @{$chr{$F[0]}}, [ @F[1, 2] ]; $isDB = eof; }` [download]	[reply] [d/l]
Re^4: Searching and Coutning using 2 files with multiple columns by shart3 (Novice) on Sep 17, 2009 at 15:27 UTC
Thanks. PROBLEM SOLVED!! Your original post worked! I had to remove a hard return in my text file that was screwing everything up	[reply]
Re^5: Searching and Coutning using 2 files with multiple columns by ccn (Vicar) on Sep 17, 2009 at 17:48 UTC


XP is just a number
	PerlMonks