Convert cell arrays into single array

Question

Getting started with Matlab and mySQL, as a result for my query I get this type of array:

my_result =

  5×1 cell array

    {'a'}
    {'b'}
    {'c'}
    {'d'}
    {'e'}

I'd like to get a simple array like this:

[a, b, c, d, e]

Here's my code:

mysql( 'open', 'my_database', 'usr','passw' )

query = fileread('query1.sql');           
query = sprintf(query)

my_result = mysql(query);

And my attempts at getting a simple array:

my_array = []
for i=1:length(my_result)
   my_array = [my_array, my_result{i}];
end


>> my_array

my_array =

    'abcde'

>> cell2mat(my_result)
Error using cat
Dimensions of arrays being concatenated are not consistent.

Error in cell2mat (line 83)
            m{n} = cat(1,c{:,n});

Is there a way to either get the correct format in the first place, or easily convert it properly? Thank you

MySQL doesn't support arrays, so your question is rather unclear. — Gordon Linoff
– Gordon Linoff, Commented Mar 5, 2021 at 23:23

bla · Accepted Answer · 2021-03-05 23:51:02Z

2

just use the cell2mat built-in function

a{1} =  'a' 
a{2} =  'b' 
a{3} =  'c' 
a{4} =  'd' 
a{5} =  'e' 


a =

  5×1 cell array

    {'a'}
    {'b'}
    {'c'}
    {'d'}
    {'e'}


cell2mat(a)

ans =

  5×1 char array

    'a'
    'b'
    'c'
    'd'
    'e'

edited Mar 5, 2021 at 23:51

answered Mar 5, 2021 at 23:31

bla

26.1k11 gold badges72 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

rioualen Over a year ago

Oh actually I tried that one, I'll update my post

bla Over a year ago

then you did get a 5x1 array of chars... what is the problem?

bla Over a year ago

from your edit you have already a char array (in the original question you started from a cell array) , is what you want is just some different way that this info is visualized? because that's how char type letters are presented.

Collectives™ on Stack Overflow

Convert cell arrays into single array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related