finding unique string variables from a column vector

2012 6 4
1 个回答
回答已采纳
2 次查看（30 天）

0 个投票

Dear all,
I insert an excel file into matlab as follows
clear
clear all
[data,text,all] = xlsread(A.xlsx');
mdata0=[all];
mdata1=num2cell(mdata0);
and I want to use the command
ismember(mdata1(:,5),unique(mdata1(:,5)))
where mdata1(:,5) contains string variables
but whenever I issue that command I get
??? Error using ==> cell.unique at 47
Input must be a cell array of strings.
Any suggestions?
thanks

请先登录，再回答此问题。

 采纳的回答

Andrei Bobrov
Andrei Bobrov 2012-6-4

0 个投票

[data,text,alld] = xlsread('A.xlsx');
mdata1 = alld(:,5);
t = cellfun(@(x)isnumeric(x),mdata1);
mdata1(t) = cellfun(@(x)num2str(x),mdata1(t),'un',0);
[out,out]= ismember(mdata1,unique(mdata1));

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by