how to read .sts file in matlab?

Question

sandy 2013-9-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/86404-how-to-read-sts-file-in-matlab

hi..i have .sts file(45000). i need to read this files in a loop and append them into an excel file. in each .sts file,it contains data like below,

SAMPLE_20130606_0006   0 +6.470299E+0 +4.009076E+0 +1.699308E+1 +1.095633E+0 
SAMPLE_20130606_0016   0 +6.938715E+0 +2.954977E+0 +1.125970E+1 +1.396087E+0 
SAMPLE_20130606_0026   0 +8.297382E+0 +4.155266E+0 +2.333013E+1 +1.611527E+0 
SAMPLE_20130606_0036   0 +8.837934E+0 +5.234266E+0 +1.352240E+1 +1.407429E+0 
SAMPLE_20130606_0046   0 +8.098710E+0 +3.642447E+0 +1.205176E+1 +1.683126E+0

how to read this file in a loop and save in excel format?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2013-9-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/86404-how-to-read-sts-file-in-matlab#answer_95924

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

xlswrite() for the file writing.

When you read the data, do you want all fields (including the text line), or do you only want the numbers? Perhaps only the last 4 numbers?

If you want everything, just broken out into fields, the consider using fileread() to read the file, and regexp() with 'split' option to break it into fields.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2013-9-10

Use fullfile() to construct the input and output file names. xlswrite() will be perfectly happy to be given a file name in a different directory.

Walter Roberson 2013-9-10

在 MATLAB Online 中打开

indir = 'INPUT';
outdir = 'OUTPUT';
finfo = dir(fullfile(indir, '*.sts'));
massoutput = {};
for K = 1 : length(finfo);
  thisfilename = fullfile(indir, finfo(K).name); 
  sts = fileread(thisfilename);
  t = regexp(regexp(regexprep(sts, ' *\n *$', ''), ' *\n', 'split'), '\s+', 'split');
  massoutput{K} = vertcat(t{:});
end
massoutput = vertcat(massoutput{:});
thisfilename = fullfile(outdir, 'allsts.xls');
xlswrite(thisfilename, massoutput);