MATLAB: How to find match using strfind from 2 different dataset sizes

indexstrfind

I currently have 2 sets of data and I am trying to find a match based off of it's name. For example in data1 it contains apple, banana, orange, pear,etc and data 2 contains apple-1, apple-2, apple-3, banana-1, banana-2, banana-3, orange, pear-1, pear-2, etc. Ultimately, I would like to write a script to match for example apple with apple-1, apple-2, apple-3 etc and print out the corresponding data:
Col 1 column 2
apple apple-1
apple apple-2
apple apple-3
banana banana-1
banana banana-2
banana banana-3
orange orange
pear pear-1
pear pear-2
I have the following code:
[nRows,~]=size (data2); % 6204x13 matrix
[nRows2,]=size (id); %258x1 matrix
temp2=data2.SAMPLEID;
temp3=id;
for i=2:nRows
temp4=strfind (id,data2.SAMPLEID{i});
ind= find(~isempty(temp4),1,'first');
for n=1:nRows2
sampleid{n,1}=temp3;
if ind ==1
% if ~isempty(ind{n});
sampleid{n,2}=temp2;
else
sampleid{n,2}=temp3;
end
end
temp3= id{i};
temp2=data2.SAMPLEID{i};
end

Best Answer

d1 = {'apple'; 'orange';'banana'; 'pear'}
d2 = {'apple-1'; 'pear-1'; 'apple-2';'banana-3'; 'orange'; 'apple-3'; 'banana-1';'banana-2'; 'pear-2'}
[v,iii] = sort(d2);
p = strcat(d1(1:end-1),{'|'});
p = strcat([p{:}],d1{end});
pp = regexp(d2,p,'match');
pp = cat(1,pp{:});
[~,ij] = ismember(pp,d1);
dd1 = d1(ij);
out = [dd1(iii),v]
Related Question