Convert string to a cell, array or matrix

Hi everyone,

I was wondering how I could convert an string to array or matrix.

Thanks very much.

Answer 1

[Titus Edelhofer]

Hi Alfonso,

first of all, you might consider using the variable "NUM", since it already contains the numbers as double variable. So no need to convert anything. You usually use the RAW format, when the format of the EXCEl file changes, i.e., the indexing into NUM get's more complicated. If RAW(2:end, 65) contains only numbers (as numbers, not strings), probably simply doing

FaceRecall = cell2mat(RAW(2:end, 65));

or

FaceRecall = [RAW{2:end, 65}]';

should both work ...

Titus

[Titus Edelhofer]

But as I said, maybe

NUM(:, 65)

leads to the same ...

Titus

[Alfonso Lopez]

Yes, the two answers works very good. Thanks very much!! :)

Answer 2

[Titus Edelhofer]

What about this one:

doc str2num

Titus

[Alfonso Lopez]

I've tried to do this but unfortunately the output is 0... Could you give any other example which I could extrapolate to my data, please?

Answer 3

[Thorsten]

A string is a 1Xn matrix of type char

S = 'hallo';

You can convert it to a numerical matrix using

M = double(S);

If that is not what you want, please give us more details, and a sample string.

[Alfonso Lopez]

Sorry I'm a beginner in this. I put all I did until moment:

[NUM,TXT,RAW]=xlsread('data.xlsx'); % Open excel data

condition=RAW(2:end,121); % CONDITIONS

subject=RAW(2:end,118); % SUBJECTS

FaceRecall=RAW(2:end,65); % Asign variable

The problem is that this variable appear "{}FaceRecall" in my workspace and when I try to do the mean appears a mistake. I think it's because is not a numeric variable so I would like to know how to convert it.

I don't know if I explain in the best way. Sorry for my English.

[Thorsten]

Please post the data.xlsx file such that we can have a closer look.