Here you go :-) 
#!/perl/bin/perl
use strict;

print "\n  BCG          LOCATION        TRX       STATUS";
print "\n  ---------------------------------------------\n";
my $bcg;my $location; my $trx; my $status;
while(<DATA>){
chomp;
$bcg = $1 if /\b(BCG-\d+)\s+/ig;
$location = $1 if /\b(SNBX\w+)\b/ig;
if( /\s+(TRX-\d+)\s+\w\s+(BL-TRX)/ig){
$trx = $1; $status=$2;
write;
}
}

format STDOUT =
  @<<<<<<    @<<<<<<<<<<<    @<<<<<<<    @<<<<<<
$bcg, $location, $trx, $status
.


__DATA__
BCG-011  ULTRASITE     U  WO                                1 BC011 WO
+ 
 05823 00051 BTS-025   U  WO                              0   0  
 SNBXCASD005X     RF                                                  
+         3 
              TRX-001  U  BL-TRX      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 
BCG-012  ULTRASITE     U  WO                                1 BC011 WO
+ 
 05823 00051 BTS-025   U  WO                              0   0  
 SNBXCASD125T     RF                                                  
+         3 
              TRX-031  U  BL-TRX      713  0  117 MBCCH         P 4 
              TRX-012  U  BL-TRX      729  0  117                 0 
 05823 00052 BTS-026   U  WO                               0   0 
 SNBXLASD995Y     RF                                                  
+        3 
              TRX-005  U  WO      722  0  117 MBCCH         P 3 
              TRX-106  U  BL-TRX  731  0  117                 8 
 05823 00053 BTS-027   U  WO                                0   1

[download]
Isn't perl great! :-)

In reply to Re: Newbie Needs Help! by JamesNC
in thread 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.