Determine which cells contain elements of another cell

fileNames = [{'.'}, {'..'}, {'1.bin'}, {'1_Report.txt'}, {'2.bin'}, {'2_Report.txt'}, {'3.bin'}, {'3_Report.txt'}, {'4.bin'}];
binNums = regexp([fileNames{contains(fileNames, '.bin')}], '\d+', 'match');
txtNums = regexp([fileNames{contains(fileNames, '_Report.txt')}], '\d+', 'match');
hasMatch = ismember(binNums, txtNums); 
processedFiles = strcat(binNums(hasMatch), '.bin');          %  = [{'1.bin'}, {'2.bin'}, {'3.bin'}];
processedIndex = find(ismember(fileNames, processedFiles));  %  = [3, 5, 7];

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Mike King 2019-4-25

Did exactly what i wanted, Thanks Adam!

请先登录，再进行评论。

Answer 2

Rik 2019-4-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/458587-determine-which-cells-contain-elements-of-another-cell#answer_372325

编辑：Rik 2019-4-25

在 MATLAB Online 中打开

A few calls to cellfun, a regexp and ismember will do the trick:

fileNames = [{'.'}, {'..'}, {'1.bin'}, {'1_Report.txt'}, {'2.bin'}, {'2_Report.txt'}, {'3.bin'}, {'3_Report.txt'}, {'4.bin'}];
bin_match=regexp(fileNames,'\.bin');%get the indices where .bin is in the filename
bin_names=fileNames(~cellfun('isempty',bin_match));%remove other files
bin_match=bin_match(~cellfun('isempty',bin_match));%remove empty elements
%find the base filename and compose the matching txt filenames
base_filename=cellfun(@(x,y) x(1:(y-1)),...
    bin_names,bin_match,'UniformOutput',0);
txt_names=cellfun(@(x) {[x '_Report.txt']},base_filename);
%find out which txt file actually is in the list and keep the matching bin file
[~,b]=ismember(fileNames,txt_names);
processedFiles = bin_names(b(b~=0));

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

Adam Danz 2019-4-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/458587-determine-which-cells-contain-elements-of-another-cell#answer_372324

在 MATLAB Online 中打开

fileNames = [{'.'}, {'..'}, {'1.bin'}, {'1_Report.txt'}, {'2.bin'}, {'2_Report.txt'}, {'3.bin'}, {'3_Report.txt'}, {'4.bin'}];
binNumMatch = regexp(fileNames, '\d+.bin', 'match'); 
binNum = [binNumMatch{:}];
fileNumMatch = regexp(fileNames, '\d+_Report.txt', 'match'); 
fileNum = [fileNumMatch{:}];
ismem = ismember(cellfun(@str2double, regexp(binNum, '\d+', 'match')), cellfun(@str2double, regexp(fileNum, '\d+', 'match'))); 
processedFiles = binNum(ismem);                              %  = [{'1.bin'}, {'2.bin'}, {'3.bin'}];
processedIndex = find(ismember(fileNames, processedFiles));  % = [3, 5, 7];