How do i delete an exact cell from a cell-matrix?

3 次查看（过去 30 天）
Christoph Thale
Christoph Thale 2016-9-7
评论： Mischa Kim 2016-9-7
Hi,
i have a 1x13 cell-txt-matrix which is read out of an excelsheet with
[num, txt, raw] = xlsread(___)
txt looks like that:
[test] [1.1.111] [2.2.2222] [empty cell] [3.3.3333]
the [ ] stands just for the cell. There are no brackets in it.
I am able to identify the coordinates from the cells i want to delete. The problem is, I cant delete these founded cells. I want to have this:
[1.1.111] [2.2.2222] [3.3.3333]
I tried to solve this problem with the approach:
txt{...} = []
The receiving:
[[]] [1.1.111] [2.2.2222] [[]] [3.3.3333]
I hope you understand my problem and have some satisfying advices.
Thanks a lot.

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

采纳的回答

Mischa Kim
Mischa Kim 2016-9-7
Christoph, simply use round brackets instead
a = {1,2,3};
a(2) = []
  3 个评论
显示 1更早的评论
Noam Weissman
Noam Weissman 2016-9-7
编辑：Noam Weissman 2016-9-7
a(2) is a cell with size 1x1.
a{2} is the content of the above cell.
You want to delete the cell itself, not only its content.
Mischa Kim
Mischa Kim 2016-9-7
I agree, this is not obvious.
There is a difference between removing a cell element and setting a cell element to "empty". Since the curly brackets are used to assign cell values, this approach is also used to assign an empty cell value. Therefore, there needs to be a different mechanism to remove a cell element. That is where the round brackets come in in.
Also note, that for matrices you use the same approach:
a = [1,2,3];
a(2) = []
a =
1 3

请先登录，再进行评论。

更多回答（1 个）

Noam Weissman
Noam Weissman 2016-9-7
编辑：Noam Weissman 2016-9-7
txt = txt([2 3 5]);
% or
txt([1 4 ])=[];
  1 个评论
Christoph Thale
Christoph Thale 2016-9-7
编辑：Christoph Thale 2016-9-7
Haha, of course i can solve it with your first attempt for this example but the cells i wont have in my cell-matrix are variable.
Thank you, the round brackets work fine.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by