How you extract the columns out depends on the file format; for CSVor TSV, I would recommend either the Text::CSVor Text::CSV_XS modules. If it is freespace columnar, I'd use split.

I would then read the broker file and store the brokers in an array.

Then I would read the ticker file, and for each line, use grepto see if the broker in that file matches anything in the array. If it does, I would store the ticker in a hash, using the broker as the key and the ticker as the value.

Useful snippets: 

my @brokerElements = split /\s+/, $brokerLine;
push @brokers, $lineElements[0];
# ...
my @tickerElements = split /\s+/, $tickerLine;
my $broker = $tickerElements[1];
my $ticker = $tickerElements[3];
my $broker_regex = quotemeta $broker;
if (grep /^$broker_regex$/i, @brokers)
{
    $tickerInfo{$broker} = $ticker;
}
# ...
foreach my $reportBroker (sort keys %tickerInfo)
{
    print "Broker $reportBroker has ticker $tickerInfo{$reportBroker}\
+n";
}

[download]

Good luck with the project.

In reply to Re: Finding a specific value in another file by marinersk
in thread Finding a specific value in another file by rajiyengar

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.