I made a hash out of the numbers to search for list. Then ran through the main list, kept the relevant matching lines, then sorted that list by the first number. While doing that I kept a running sum of each section in %sums. I wasn't sure what the output should look like.

Update: added the sum calculation. And I now see that there is some text that you want to skip, use a regex for that. Anyway you have another solution.

#!/usr/bin/perl -w
use strict;
$|=1;

my @numberList = qw (20 30 50); #you get this from a file

my %numberHash = map{$_ => 1}@numberList;

my @result;
my %sums;
while (<DATA>)
{
   chomp;
   my ($first, $second) = split;
   
   if ($numberHash{$first})
   {
      push @result, $_;
      $sums{$first}+= $second;
   }
}

@result = sort{ my($firstA) = split(' ',$a);
                my($firstB) = split(' ',$b);
                   $firstA <=> $firstB 
              }@result;

foreach (@result)
{
   my ($first) = split;
   print "$_ $sums{$first}\n";
}

#not sure what format you want output in
=prints
20 23424 332444
20 56756 332444
20 82757 332444
20 83758 332444
20 09347 332444
20 76402 332444
30 91857 364101
30 92785 364101
30 89275 364101
30 90184 364101
50 29349 184748
50 71674 184748
50 83725 184748
=cut

__DATA__
10 23432
20 23424
60 45567
20 56756
30 91857
50 29349
10 93729
80 82374
20 82757
30 92785
50 71674
70 81747
20 83758
30 89275
10 19594
60 09214
20 09347
50 83725
90 91845
20 76402
30 90184

[download]

In reply to Re: Generating a list of numbers from other lists by Marshall
in thread Generating a list of numbers from other lists by mlebel

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.