MATLAB: How can i take only the number of data and delete all the header so i can save it to xls

dataread tablexlsread

I have data that that i've attached. This data contain header every several rows. How can i just get the number (in table)? so i can save the table of number to xls and i can edit the header manually.
soperating frequency = 1575.420 MHz
PRN     UT        LT         azimuth     elevation     sat.lat      sat.long      S4     sigma_phi Angular deviation  Coh. length       PLL         DLL      C / N     Proba of LoL
                              (deg)         (deg)       (deg)        (deg)                 (rad)         (mr)             (km)         (deg)       ( m.)
   6    11.000    17.687       235.867        8.366      -31.422       36.279       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
  12    11.000    17.687        54.551       12.873       31.175      158.771       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
  14    11.000    17.687       350.843       21.669       54.277       87.315       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
  18    11.000    17.687        66.853       54.594       10.231      125.741       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
  21    11.000    17.687       170.715       42.325      -36.873      107.311       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
  22    11.000    17.687         4.442       46.250       33.893      103.307       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
  25    11.000    17.687        77.902       41.379        7.292      137.881       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
  29    11.000    17.687       135.787        9.676      -41.239      158.633       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
  30    11.000    17.687       200.767       24.016      -48.863       74.646       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
  31    11.000    17.687       264.066       53.997       -2.944       72.583       0.00      0.00           0.00          0.00           0.00        0.00      0.00         0.000
 10 satellites in view

Best Answer

s = fileread('6jan2008s4.txt');
temp = regexp( regexprep(s, {'^.*[a-zA-Z].*', '^\s+'}, {'', ''}, 'lineanchors', 'dotexceptnewline'), '\r?\n', 'split');
temp(cellfun(@isempty, temp)) = [];
temp2 = regexp(temp,'\s+', 'split');
num = str2double( vertcat(temp2{:}) );
Now num is all numeric and you can write it as appropriate.
Related Question