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.

 采纳的回答

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

2 个评论

But as I said, maybe
NUM(:, 65)
leads to the same ...
Titus
Yes, the two answers works very good. Thanks very much!! :)

请先登录,再进行评论。

更多回答(2 个)

What about this one:
doc str2num
Titus

1 个评论

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?

请先登录,再进行评论。

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.

2 个评论

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.
Please post the data.xlsx file such that we can have a closer look.

请先登录,再进行评论。

类别

帮助中心File Exchange 中查找有关 Numeric Types 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by