Sorting a Cell Array

Hi,

Sorry if this has been asked / answered many times or very simple etc. etc!

If I have a cell array say Array = {B C A;1 3 2; D E F}

Is it possible to sort the first row in order, so its A B C, with the second and third rows changing corresponding to to this initial sort?

Final answer being {A B C;2 1 3;F D E}

Thanks in advance Matthew

Answer 1

[Andrei Bobrov]

Array = {'B' 'C' 'A';1 3 2; 'D' 'E' 'F'}
out = sortrows(Array',1)';

OR

[id id] = sort(Array(1,:))
out = Array(:,id)

[NALLARASU KRISH]

What this syntax sortrows(Array',1)'; means? That is, how to interpret this? It looks like a weird syntax. But worked well. Thank you!

[NALLARASU KRISH]

What is the syntax for sorting cell arrays in descending order? Thank You!

[Ananya]

sortrows(Array',1)':: here since sortrows works for columns ,(sorting elements in a column of a matrix...)

you needed the row to be sorted here , so Array' is the transpose of it and then doing a retranspose of the result by doing sortrows(Array',1)'<-- to get the original matrix

for descending its simple, just add 'descend' at the end of these arguments (Array',1,'descend')'

Answer 2

[Andreas Goser]

It is not clear to me what your cell array really looks like, as your example is not valid, but the SORTROWS command should work.

Answer 3

[Matthew]

Sorry if not clear...

The array consists of both strings and numbers

so Array = {'B' 'C' 'A';1 3 2;'D' 'E' 'F'}

where the letters are strings and the numbers numbers!

i tried the sortrows and it did not work

Thanks again, matthew

Answer 4

[Matthew]

Apologies again!

Thanks to Andrei, works perfectly!