how to manipulate a cell

2013 11 24
2 个回答
回答已采纳
更新时间：2013 11 25
1 次查看（30 天）

0 个投票

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

0 个投票

A={1800742;0;0;0;[];[];1.4400;0;0;[];0}
A(cellfun('isempty',A))={'none'}

22 个评论
显示 20更早的评论 隐藏 20更早的评论

Navid
Navid 2013-11-24
Thanks for your answer,
unfortunately it did not work.
maybe because the blank places in the cell are like ;;; not like [];[];[]
could it be the reason?
Azzi Abdelmalek
Azzi Abdelmalek 2013-11-24
A={1800742 ;';' ;0;0;0; ';' ;1.4400;0;0;';';0}
B=cellfun(@num2str,A,'un',0)
A(strcmp(B,';'))={'none'}
Navid
Navid 2013-11-24
could you please explain about lines? I'm getting error,maybe I should change something.
Thanks
Azzi Abdelmalek
Azzi Abdelmalek 2013-11-24
Can you explain how your data looks like?
Navid
Navid 2013-11-24
yes sure, there is a 1621x1 cell,and this is on of the rows:
;1800742;0,0000;0,0000;0,0000;1,4400;0,0000;0,0000;0,0000;0,0000;0,0000;0,0000;0,0000;0,0000;0,0000;2,5500;;;;;;0,0000;-8,8000;12,1600;12,1600;15,0000;0,0000;-0,5000;
As you in the second line there is ;;;;;; ,it means there is no value,and I need to fill this places like this:
;1800742;0,0000;0,0000;0,0000;1,4400;0,0000;0,0000;0,0000;0,0000;0,0000;0,0000;0,0000;0,0000;0,0000;2,5500;none;none;none;none;none;0,0000;-8,8000;12,1600;12,1600;15,0000;0,0000;-0,5000;
Many thanks for your attention.
Azzi Abdelmalek
Azzi Abdelmalek 2013-11-24
编辑：Azzi Abdelmalek 2013-11-24
If A is your array, when type
A(1:20)
What do you get?
Navid
Navid 2013-11-24
as I told you the cell is 1621x1,I mean there is 1621 rows and just one column. all of mentioned values are in the first row and first column.
actually I had an ASCII file and import it.this is my code for importing part:
fed = fopen('Antos_2013-11-07_07-08-58.asc');
mydata = textscan(fed,'%s');
it gives me "mydata" which is a cell with 1621 rows and one column.
Navid
Navid 2013-11-24
I should add that when I type mydata(1:20) I'm getting this error:
Index exceeds matrix dimensions.
Error in plotrand (line 3)
mydata(1:20);
Azzi Abdelmalek
Azzi Abdelmalek 2013-11-24
Ok then type
whos mydata
whos mydata{1}
Navid
Navid 2013-11-24
I got this:
mydata 1x1 12422212 cell
Navid
Navid 2013-11-24
I've already written you,it gives me:
Name Size Bytes Class Attributes
mydata 1x1 12422212 cell
Navid
Navid 2013-11-24
should I do something else?
could you tell me please what is the problem?
Navid
Navid 2013-11-24
it gives:
Name Size Bytes Class Attributes
c 16201x1 12422100 cell
Azzi Abdelmalek
Azzi Abdelmalek 2013-11-24
编辑：Azzi Abdelmalek 2013-11-24
TRY THIS
B=cellfun(@num2str,mydata{1},'un',0)
mydata(~cellfun('isempty',regexp(B,';+','start')))={'none'}
Navid
Navid 2013-11-24
sry for taking your time but it gives a cell which is not still correct:
mydata 1x16200 1944000 cell
and in all 16200 elements has been written none.
I think I need to change the code to get correct result,could you just explain the lines please,I just need to understand how does it work.
Thanks
Azzi Abdelmalek
Azzi Abdelmalek 2013-11-24
编辑：Azzi Abdelmalek 2013-11-24
doc cellfun
doc regexp
Post a sample of your file
Navid
Navid 2013-11-24
my file is something like this attachment.
and this is the code for importing:
fed = fopen('sample.txt');
mydata = textscan(fed,'%s');
Azzi Abdelmalek
Azzi Abdelmalek 2013-11-24
Can you explain what a comma , represent in your file, and how your data are separated, and the type your data :string or double? You can read your file line by line
fid = fopen('sample.txt');
res={};
while ~feof(fid)
res{end+1,1} =fgetl(fid);
end
fclose(fid);
celldisp(res)
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

0 个投票

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

类别

在 帮助中心 和 File Exchange 中查找有关 Programming Utilities 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by