how to split the string to cells?

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

0 votes

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