Search for a specific string in a dataset

Hi all,

I have a dataset (SDEV) with 4 columns (ID,Name,ImageFile,Tel). I try to create a new dataset with only ID and Name for all data with ImageFile contains only word 'fixed'. My ImageFile contains very long string like 'document/test/fixed/image/001_controlled', 'document/test/shaked/image/001_controlled', etc.

I code like this:

    load SDev;
    h1 =SDev(SDev.ID==3 & SDev.ImageFile=='.*fixed*',{'ID' 'Name'})

and it gave me error: Undefined function 'eq' for input arguments of type 'cell'.

Thank you in advance.

Answer 1

[Image Analyst]

It probably doesn't like this SDev.ImageFile=='.*fixed*'

ImageFile might be a cell. And you should use strcmpi() instead o f== for comparing strings

strcmpi(char(SDev.ImageFile), '.*fixed*')

[Nurul Ain]

Hi Image Analyst,

Thank you for your reply. I made correction to my code:

h1 =SDev(SDev.ID==3 &  strcmpi(char(SDev.ImageFile), '.*fixed*'),{'ID' 'Name'})

and it return me:

h1 = empty 0-by-2 dataset