using ismember or something else

Hi All,

I have a dataset 'RestInfo' like this.

 Name               location    startNum    Q1Earning   Q2Earning  
Restaurant1          South       second       10           7.9          Restaurant2          West        first        11           17.39    
nameHolder2          unknown     notOpen       0             0            Restaurant1_Annex    West        first        11           13.34         Restaurant3          EastSide    third        8.3           7.1       
nameHolder1          unknown     notOpen       0             0       

I have global variable 'gNames' 1x2 cell gNames = 'Restaurant1' 'Restaurant2' 'Restaurant3'

now from 'RestInfo' I just want to get rows which has names matching with in gNames, and also those which has starting name matching , so that in new dataset I get following

Name               location    startNum    Q1Earning   Q2Earning  
Restaurant1          South       second       10           7.9          Restaurant2          West        first        11           17.39    
Restaurant1_Annex    West        first        11           13.34         Restaurant3          EastSide    third        8.3           7.1       

I was able to ismember as follow but then it does not get me Restaurant1_Annex.

     newInfo =  RestInfo(ismember(RestInfo.Name, gNames),:); 

What should I do so that Restaurant1_Annex is not missing from my final newInfo dataset?

Answer 1

[Star Strider]

Instead of the ismember function I would use the setdiff function.

[Image Analyst]

What about strfind()? And how about spelling Restaurant consistently?

[Neesha]

Yes I do have fat finger .....sorry about the spelling, yes it is consistent in my dataset.

I know strfind, but I do not know how to apply to the entire dataset.