how to find unique values with matlab in cell array

Question

How do I find unique cells in excel using matlab? i was trying to get all unique strings in some excel field, so baisicly im trying to do somthing like this:

[~,~,mainraw] = xlsread(mainfilename,1); 
unique_expense_types = unique(mainraw(:,2));

it should have goten all the cells into cell array type and then return full strings that are unique, though i receive this output:

ans =

'  "'()-./01245689BEGILMORWY'

please help fixing it

question from:https://stackoverflow.com/questions/65602870/how-to-find-unique-values-with-matlab-in-cell-array

Answer 1

Waitting for answers