How can i take only the number of data and delete all the header so i can save it to xls?
1 回表示 (過去 30 日間)
古いコメントを表示
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
0 件のコメント
採用された回答
Walter Roberson
2017 年 10 月 23 日
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.
9 件のコメント
Walter Roberson
2017 年 10 月 26 日
col_header={'PRN', 'UT', 'LT', 'azimuth (deg)', 'elevation (deg)', 'sat.lat (deg)', 'sat.long (deg)', 's4 (rad)', 'sigma_phi (mr)', 'Angular Deviation (km)', 'Coh. Length (deg)', 'PLL (m.)', 'DLL', 'C/N', 'Proba of LoL'}; %Row cell array (for column labels)
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Data Type Conversion についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!