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

2019 3 4
1 个回答
回答已采纳
更新时间：2019 3 4
33 次查看（30 天）

0 个投票

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.

请先登录，再回答此问题。

 采纳的回答

KSSV
KSSV 2019-3-4

1 个投票

[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.

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Abdullah Hamidi
Abdullah Hamidi 2019-3-4
编辑：Abdullah Hamidi 2019-3-4
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
KSSV 2019-3-4
Ohhh...
C4(idx)
The above gives you the respective strings....
Abdullah Hamidi
Abdullah Hamidi 2019-3-4
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
KSSV 2019-3-4
Ohhh....simple:
[num,txt,raw] = xlsread(myfile) ;
C4 = txt(:,4) ;
idx = contains(C4,'DEB')
iwant = txt(idx,:)

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 String 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by