You are now following this question
- You will see updates in your followed content feed.
- You may receive emails, depending on your communication preferences.
how to manipulate a cell
1 view (last 30 days)
Show older comments
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
Accepted Answer
Azzi Abdelmalek
on 24 Nov 2013
A={1800742;0;0;0;[];[];1.4400;0;0;[];0}
A(cellfun('isempty',A))={'none'}
22 Comments
Azzi Abdelmalek
on 24 Nov 2013
A={1800742 ;';' ;0;0;0; ';' ;1.4400;0;0;';';0}
B=cellfun(@num2str,A,'un',0)
A(strcmp(B,';'))={'none'}
Azzi Abdelmalek
on 24 Nov 2013
Can you explain how your data looks like?
Navid
on 24 Nov 2013
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
on 24 Nov 2013
Edited: Azzi Abdelmalek
on 24 Nov 2013
If A is your array, when type
A(1:20)
What do you get?
Navid
on 24 Nov 2013
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.
Azzi Abdelmalek
on 24 Nov 2013
Ok then type
whos mydata
whos mydata{1}
Azzi Abdelmalek
on 24 Nov 2013
whos mydata{1}
Azzi Abdelmalek
on 24 Nov 2013
Type
c=mydata{1}
whos c
Azzi Abdelmalek
on 24 Nov 2013
Edited: Azzi Abdelmalek
on 24 Nov 2013
TRY THIS
B=cellfun(@num2str,mydata{1},'un',0)
mydata(~cellfun('isempty',regexp(B,';+','start')))={'none'}
Navid
on 24 Nov 2013
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
on 24 Nov 2013
Edited: Azzi Abdelmalek
on 24 Nov 2013
doc cellfun
doc regexp
Post a sample of your file
Azzi Abdelmalek
on 24 Nov 2013
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
on 24 Nov 2013
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
on 24 Nov 2013
Edited: Azzi Abdelmalek
on 24 Nov 2013
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'}
See Also
Categories
Find more on Get Started with MATLAB in Help Center and File Exchange
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!An Error Occurred
Unable to complete the action because of changes made to the page. Reload the page to see its updated state.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)
Asia Pacific
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)