how to split the string to cells?

1 次查看（过去 30 天）
sandy
sandy 2013-8-12
i have a text file contains following data,
SAMPLE_20120807_1806 0 +1.122117E+1 +7.190077E+0 +1.460343E+1
..i opened this and,but the output variable stored this line in a single cell itself like this (1*234 char).but i need to split each and values to be stored in separate cells in excel file...i stuck here..can anyone suggest code there in matlab?
%if true
folder='F:\run\';
file=fullfile(folder,'SAMPLE_20120807_1806.run');
a=fileread(file);
dlmwrite('file.xls',a,'');
%end

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-8-12
s='SAMPLE_20120807_1806 0 +1.122117E+1 +7.190077E+0 +1.460343E+1'
regexp(s,' ','split')
  2 个评论
sandy
sandy 2013-8-12
hi azzi... for single file to split is done..but i have 10 files to split like and append al files to single excel file is problem here nw,help me.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by