how to split the string to cells?

1 vue (au cours des 30 derniers jours)
sandy
sandy le 12 Août 2013
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
  1 commentaire
sandy
sandy le 13 Août 2013
can anyone tel me how to put this in a loop?

Connectez-vous pour commenter.

Réponse acceptée

Azzi Abdelmalek
Azzi Abdelmalek le 12 Août 2013
s='SAMPLE_20120807_1806 0 +1.122117E+1 +7.190077E+0 +1.460343E+1'
regexp(s,' ','split')
  2 commentaires
sandy
sandy le 12 Août 2013
thanks...it works..
sandy
sandy le 12 Août 2013
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.

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by