how to manipulate a cell

1 次查看(过去 30 天)
Navid
Navid 2013-11-24
回答: Navid 2013-11-25
Hi I have 1621x1 cell and each row is something like this: ;1800742;0,0000;0,0000;0,0000;;;;;;;1,4400;0,0000;0,0000;0,0000;0,0000;
";" is delimiter between different values.
I need to find the blank places in each row and fill it with a word like "None". As a beginner I need to know how can I access the blank places?is it possible to at first store the values in an array and then find the blank places?if yes how can I do that?
I would really appreciate any helps.
Thanks,Navid

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-11-24
A={1800742;0;0;0;[];[];1.4400;0;0;[];0}
A(cellfun('isempty',A))={'none'}
  22 个评论
Navid
Navid 2013-11-24
the numbers are floating point and the comma represent that,for example:(10,5 represent 10.5)
and the different numbers are separated by semicolon it could be string or double,i just need to fill the blank places(the places which there is nothing between two semicolons ) with "none".
Azzi Abdelmalek
Azzi Abdelmalek 2013-11-24
编辑:Azzi Abdelmalek 2013-11-24
Try this
clear
fid = fopen('sample.txt');
res={};
while ~feof(fid)
res{end+1,1} =fgetl(fid);
end
fclose(fid);
A=strrep(res,',','.');
B=regexp(A,';','split');
for k=1:numel(B)
C(k,:)=B{k};
end
C=cellfun(@str2double,C,'un',0);
idx=isnan(cell2mat(C));
C(idx)={'none'}

请先登录,再进行评论。

更多回答(1 个)

Navid
Navid 2013-11-25
Dear Azzi Abdelmalek
Many thanks for your times and helps,it works great.this is exactly what I wanted. thank you so much.
Best,Navid

类别

Help CenterFile Exchange 中查找有关 Get Started with MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by