Filter cell array by some string value

Question

I have a cell array, something like this:

A = 

    '5523'    '2012-10-26'    '23'    'T'    '17.7'
    '5513'    '2012-10-26'    '23'    'T'    '22.1'
    '5506'    '2012-10-26'    '23'    'C'    '16.2'

Now I would like to filter all records that have T. So I would like to get this array:

A = 

    '5523'    '2012-10-26'    '23'    'T'    '17.7'
    '5513'    '2012-10-26'    '23'    'T'    '22.1'

I could parse all array, but is there any other way?

shoelzer · Accepted Answer · 2013-01-15 16:45:20Z

6

Here's a one-liner to do it:

A = A(strcmp(A(:,4), 'T'), :);

The inner part, strcmp(A(:,4), 'T'), is comparing column 4 of all rows to 'T'. Then that boolean vector can extract matching rows from A with logical indexing.

answered Jan 15, 2013 at 16:45

shoelzer

10.7k2 gold badges31 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

shoelzer Over a year ago

@llnk I know what you mean. But once you get used to logical indexing and matrix operations, "classic programming" seems very verbose and can be quite frustrating!

Eitan T Over a year ago

@llnk MATLAB is more oriented toward functional programming and favors vector operations. It looks very elegant once you get used to it.

Collectives™ on Stack Overflow

Filter cell array by some string value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related