How to extract the values that I want in a cell array?

Hey all,

If we have: a={'1,17951,1,0' ; '1,20345,1,0' ; '1,22950,1,0' ; '1,25360,1,0'};

and I want to exclude 1,...,1,0 which are the same in all and as a result have cell array b as b = {17951 ; 20345 ; 22950 ; 25360}; how can I do that?

Thank you so much for your hint in advance.

Mehdi :)

Answer 1

[Andrei Bobrov]

b = regexp(a,'\d\d\d\d\d','match')
b = cat(1,b{:})

Answer 2

[Wayne King]

How is this different than the answer I gave before?

a={1,17951,1,0 ; 1,20345,1,0 ; 1,22950,1,0 ; 1,25360,1,0};
b = cellfun(@(x) x(x>1),a,'uni',0);
b(cellfun(@isempty,b))=[];

[Wayne King]

look at b that contains what you want

[M G]

No, this one is different. The previous one worked perfectly. I realized that my actual values are in |''| e.g. |'1,17951,1,0'|instead of |1,17951,1,0|.

Answer 3

[Fangjun Jiang]

I would use the comma as a way to split them and the select the second column.

a={'1,17951,1,0' ; '1,20345,1,0' ; '1,22950,1,0' ; '1,25360,1,0'};
b=regexp(a,',','split');
c=cellfun(@(x) x{1,2},b,'uni',false);
d=str2double(c)

[Andrei Bobrov]

Hi Fangjun! Variant:

b = regexp(a,',','split');

b = sortrows(cat(1,b{:})')'

b = b(:,end)