Guys, This is probably a really easy problem to solve for most of you. However, being new to Perl I am having all kinds of problems getting anything to work. I have a report file that has something like the following data in it:

BCG-011  ULTRASITE     U  WO                                1 BC011 WO
+ 
 05823 00051 BTS-025   U  WO                              0   0  
 SNBXCASD005X     RF                                                  
+         3 
              TRX-001  U  WO      713  0  117 MBCCH         P 4 
              TRX-002  U  WO      729  0  117                 0 
 05823 00052 BTS-026   U  WO                               0   0 
 SNBXCASD005Y     RF                                                  
+        3 
              TRX-005  U  WO      722  0  117 MBCCH         P 3 
              TRX-006  U  BL-TRX  731  0  117                 8 
 05823 00053 BTS-027   U  WO                                0   1

[download]

What I need is for perl to parse out which TRX has BL-TRX status (TRX-006 in the above case) and which SNBX does it belong to (SNBXCASD005Y in the above case) and finally which BCG is it in (BCG-011 in the above case). I would like to generate a report that says something like:
BCG          LOCATION        TRX         STATUS
------------------------------------------------
BCG-011    SNBXCASD005Y    TRX-006       BL-TRX

[download]
Any help you can provide will be much appreciated...
A.N.C.

update (broquaint): title change (was Newbie Needs Help!)

In reply to Getting a Human Readable Report from a data file by gargs

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.