MATLAB Answers

Cell array row deletion

19 views (last 30 days)
Daniela Valdez
Daniela Valdez on 19 Jan 2021
Edited: Adam Danz on 20 Jan 2021
Hi! I have a cell array with a 10647x16 dimension. In the first column I have an identifying name for each row. I want to delete the rows that match the column names I have. I'll put a picture for better reference.
I want to delete the rows that match the 'filename' I write. I need to delete 40 rows.

  0 Comments

Sign in to comment.

Answers (2)

Fangjun Jiang
Fangjun Jiang on 19 Jan 2021
c={'a',1,2;'b',3,4}
index=strcmp(c(:,1),'a')
c(index,:)=[]

  3 Comments

Daniela Valdez
Daniela Valdez on 19 Jan 2021
Thanks! I have 40 files that I need to delete and it says it is overflowed. That there are a lot of arguments.
Fangjun Jiang
Fangjun Jiang on 20 Jan 2021
What do you mean 40 files? 40 filenames maybe?? You can remove multiple rows in one shot.
c={'a',1,2;'b',3,4;'c',1,2;'d',2,3;'e',5,6}
filenames={'b';'d'}
index=ismember(c(:,1),filenames);
c(index,:)=[]
Adam Danz
Adam Danz on 20 Jan 2021
If you want to match strings ignoring case, use strcmpi instead of strcmp.
If you're matching to more than 1 string while ignoring case, use
ismember(lower(c(:,1)), lower(filenames)) % or upper()

Sign in to comment.


Image Analyst
Image Analyst on 19 Jan 2021
Use ismember(). Something like...
fileNamePattern = 'MUSE20180113_171327_27000';
% Compare this character array to the list of them in column 1 of ca (the cell array)
% and find out which row contains it.
[~, row] = ismember({fileNamePattern}, ca(:, 1));
% Delete it
if ~isempty(row)
ca(row, :) = [];
end
Attach your cell array if that doesn't work.

  2 Comments

Daniela Valdez
Daniela Valdez on 19 Jan 2021
Hi! I want to delete 40 files but I can't with this method. I get the following error: Subscript indices must either be real positive integers or logicals.
Image Analyst
Image Analyst on 20 Jan 2021
Did you miss the last sentence in my answer? I'll check back tomorrow for it.

Sign in to comment.

Products


Release

R2015a

Community Treasure Hunt

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

Start Hunting!