Remove white space or???

I will try dbkruger's solution.  You actually answered two questions in one here.

To answer ozo's question:  This data comes out every hour in exactly the same format and order.  The headers are ALWAYS the same as you saw them.  The only thing that might change is the first line of data.  It may not be   362 301Z.  (Site 301Z) and the last site might not be the same in the data so I can't say stop a loop when the site = XXX.

Using Visual basic I could just:

Dim Ky as integer:X as integer
Dim Site as string
Dim Dat(32) as long

'after I got past the headers
Do
   input #1,ln
   input #1, Ky:if Ky = 0 then exit for   '  This would get me to the end of the data.  The last Input #1, Ky is acting on a line like this "--------"
   input #1, Site
   for X = 1 to 32
      input #1,Dat(x)
   next X
   print #2, Site;",";
   for X = 1 to 31
      print #2, Dat(x);",";
   next x
   print #2, Dat(32)
loop

Thank you for your comments - I'll get back to you ASAP.

I'm a little confused??  It looks like the if statement is saying if the line is blank then get the data values from it else  $csv .= $line??  Guess I better look in the Perl book I have to figure out what that means.  Told you I am a real novice.

use strict;
my $csv = "";
while (my $line = <>) {
  chomp $line; #strip off newline
  if ($line eq "") {
    $csv =~s/^\s+//; # replace leading spaces with nothing
    $csv =~s/\s+$//; #replace trailing spaces with nothing
    $csv =~ s/\s+/, /g; # replace every group of one or more spaces with comma space
    print $csv, "\n";
     $csv = "";
  } else {
     $csv .= $line;
  }
}
I hope to have time to get to this Tuesday.  
Thanks.

Here is sample data with just TWO records (of the 150 or so)   So you are seeing the begining to end
       
        CAUCPSCT
              KEY (CELL_NUMBER)
                CAUPGRES   CAUNOFOF   CAUTSUCC   CAUTBLKS   CAUEDLOT    CAUTRLS
                CAUOATTS   CAUOSUCC   CAUOBLKS   CAUORODR    CAUORLS   CAUERSFL
                CAUERLFL   SLTPGRES   CAUHINIT   CAUHATTS   CAUHBLKS   CAUHRLFL
                CAUHSUCC    CAUHRLS   CAUDROPR   CAUDROPN   CAUESWFL   CAUNOTCE
                CAUFWCAP   CAURECAP   CAUNOWCD   MCTAHRQF   MCTALLTO   MCTALLFU
                MCTAREQF   MCTAMIXF
        #  Just one space here   FROM HERE TO.....
         361 301Y
                      12          0         12          0          0          0
                      19         18          0          0          0          0
                       1         12          0          0          0          0
                       0          0          0          0          0          0
                       0          0          0          0          0          0
                       0          0
     #  just one blank line here     .....HERE IS ONE RECORD WITH 34 FIELDS
         362 301Z
                       7          0          7          0          0          0
                      15         15          0          0          0          0
                       0          7          0          0          0          0
                       0          0          1          0          0          0
                       0          0          0          0          0          0
                       0          0
        # Just one blank line and this is the end of the records  This is where I need to stop.
             ------------------------------------------------------------------  
                    2147          0       2108          5          0         15
                    4393       4267         27          0         39         28
                      77       2147         89         89          0          2
                      87          0         88          2          0         28
                       0          0          0          0          0          0
                       0          0

So one record that I would write to a .csv file would look like this using the first record above:
361,301Y,12,0,12,0,0,0,19,18,0,0,0,0,1,12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

Hope this explains what I am working with better.  I also tried what dbkruger sent (exactly as written above) and I have to do a ctrl C to stop it.  Runs forever.  Maybe I put it in wrong ???

Thanks again.