Re^2: Searching and Coutning using 2 files with multiple columns

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]

Comment on Re^2: Searching and Coutning using 2 files with multiple columns Select or Download Code

Replies are listed 'Best First'.
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
OK. And now you have a challenge to understand why does it work. :)	[reply]