I want to ascend cell

hey , I want to ascend the rows based on a specific columns in the cell array . here's an example
The input in work space is
cellmobility{1,1}
x 4
y 2
z 1
g 3
the output i seek in work space is
cellmobility{1,1}
z 1
y 2
g 3
x 4

 Accepted Answer

Thomas
Thomas on 18 Jun 2012
There might be an easier way of doing this but the following should work..
a{1,1}={'x 4';'y 2';'z 1';'g 3'};
a{1,1}
p=cell2mat(a{1,1}); %convertign to mat
check=str2double(cellstr(p(:,3))); % getting col 3, i.e. the num to sort
[l,row]=sort(check); % sorting
out{1,1}=p(row,:); % reorder according to sort
out{1,1}

2 Comments

well, Its working but i was making x and y and z and g for simplicity assume these variables are numbers .,
a{1,1}=[10 4 4;5 4 2;3 4 1;2 4 3];
a{1,1}
p=(a{1,1}); %convertign to mat
check=(p(:,3)); % getting col 3, i.e. the num to sort
[l,row]=sort(check); % sorting
out{1,1}=p(row,:); % reorder according to sort
out{1,1}

Sign in to comment.

More Answers (1)

c{1,1} = cellstr(sortrows(char(c{1,1}),3));

Categories

Find more on Operators and Elementary Operations in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!