I have been assigned to extract certain data out of a data file that is in a report format. Not even sure where to begin with this one. I do not need any of the header, just the data in each column. I have attached (in 'code' form) a sample of the file. This file could be 10 pages long, but should always follow this same format. Note: This is a wide report. Any suggestions would be wonderful! Thanks! 
 *****.0.0[=3h
12/09/2009                                           ADVISOR PERFORMAN
+CE REPORT                                                3611 
11:31:02                        DEPT: ALL, MAKE: ALL, BILL TYPE: CWI, 
+FROM: 12/03/2009 TO: 12/03/2009                     PAGE 9
                                                           ADVISORS: A
+LL                                                            
SERVICE ADVISOR     MK DEPT RO.CNT   
------------------- -- ---- ---------

               CUSTOMER     WARRANTY     INTERNAL     CUSTOMER     WAR
+RANTY     INTERNAL                         LABOR
               LABOR SALE   LABOR SALE   LABOR SALE   PARTS SALE   PAR
+TS SALE   PARTS SALE   SUPPLIES  DISCOUNTS DISCNT TOTALS
               ------------ ------------ ------------ ------------ ---
+--------- ------------ --------- --------- ------ ------------
STEVEN JONES        FO SERV       1    (0)  C(0)    W(0)    I(0)   

SALES                  0.00         0.00         0.00         0.00    
+     0.00         0.00      0.00      0.00   0.00%            
GROSS PROFIT $         0.00         0.00         0.00         0.00    
+     0.00         0.00      0.00                          0.00
GROSS PROFIT %         0.00%        0.00%        0.00%        0.00%   
+     0.00%        0.00%     0.00%                        0.00%
AVG. SALES/RO          0.00         0.00         0.00         0.00    
+     0.00         0.00                                    0.00
TOTAL HOURS            0.00         0.00         0.00                 
+                                                          0.00
AVG. HOURS/RO          0.00         0.00         0.00                 
+                                                          0.00
EFF LBR RATE           0.00         0.00         0.00                 
+                                                          0.00
PRESS RETURN FOR  .2.0
12/09/2009                                           ADVISOR PERFORMAN
+CE REPORT                                                3611 
11:31:05                        DEPT: ALL, MAKE: ALL, BILL TYPE: CWI, 
+FROM: 12/03/2009 TO: 12/03/2009                     PAGE 10
                                                           ADVISORS: A
+LL                                                            
SERVICE ADVISOR     MK DEPT RO.CNT   
------------------- -- ---- ---------

               CUSTOMER     WARRANTY     INTERNAL     CUSTOMER     WAR
+RANTY     INTERNAL                         LABOR
               LABOR SALE   LABOR SALE   LABOR SALE   PARTS SALE   PAR
+TS SALE   PARTS SALE   SUPPLIES  DISCOUNTS DISCNT TOTALS
               ------------ ------------ ------------ ------------ ---
+--------- ------------ --------- --------- ------ ------------

**** T O T A L S ****   FOR STEVEN JONES               1    (0)  C(0) 
+   W(0)    I(0)   
SALES                  0.00         0.00         0.00         0.00    
+     0.00         0.00      0.00      0.00   0.00%            
GROSS PROFIT $         0.00         0.00         0.00         0.00    
+     0.00         0.00      0.00                          0.00
GROSS PROFIT %         0.00%        0.00%        0.00%        0.00%   
+     0.00%        0.00%     0.00%                        0.00%
AVG. SALES/RO          0.00         0.00         0.00         0.00    
+     0.00         0.00                                    0.00
TOTAL HOURS            0.00         0.00         0.00                 
+                                                          0.00
AVG. HOURS/RO          0.00         0.00         0.00                 
+                                                          0.00
EFF LBR RATE           0.00         0.00         0.00                 
+                                                          0.00
----------------------------------------------------------------------
+--------------------------------------------------------------
PRESS RETURN FOR

[download]

In reply to Report File Extract by jarn

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.