How do I extract a substring in a cell array of strings?

I have loaded up a catalog of satellite and space debris entries on MATLAB and I am trying to extract everything that is debris.

As you can see in the attachment (column 4), I am trying to run a for loop to look for strings that contain the word 'deb' (and other corresponding fields) and save them separately. But I am just not getting anywhere. Any help would be hugely appreciated.

Answer 1

[KSSV]

[num,txt,raw] = xlsread(myfile) ;
C4 = txt(:,4) ; 
idx = contains(C4,'DEB')

Note that for better help, you should attach your file not an image snippet.

[Abdullah Hamidi]

I tried this but it only verifies whether the string contains the specified strings. I need to extract the specified strings along with their corresponding values in other fields.

I have attached the script but I cannot attach the catalog as this platform does not support json files.

[KSSV]

Ohhh...

C4(idx)

The above gives you the respective strings....

[Abdullah Hamidi]

Thanks that worked.

Is there any way I could get the values across for those strings (as in the Satellites.JPG, e.g. the corresponding dates and ID numbers)?

[KSSV]

Ohhh....simple:

[num,txt,raw] = xlsread(myfile) ;
C4 = txt(:,4) ; 
idx = contains(C4,'DEB')
iwant = txt(idx,:)

[Abdullah Hamidi]

Perfect!!!

You're a life saver!