how to compare the elements of 2 cell arrays and get their rows from cell2?

Hi Friends, I have 2 cell arrays cell1(1*1) and cell2(1*2) I want to compare the elements of cell1 with cell2 and when all the elements of cell 1 exist in both members of cell2 then get its corresponding row from cell2.

Input:

cell1={gene1;gene2;gene3;gene4;gene5}

cell2={gene1,gene3;gene10,gene100;gene2,gene5}

output

out={gene1,gene3;gene2,gene5}

I have tried isequal and find(ismember) and get empty array.

[chocho]

Hi guys, plz help me I really need this response ASAP.

[chocho]

i have shared the 2 cells on here

[Stephen23]

@chocho: your cell arrays are nested inside other cell arrays. Your question does not mention this at all: how do you expect to get answers that actually work?

Anyway, you now have enough MATLAB experience to know how to use cell array indexing. The rest of your question can be solved using intersect.

[chocho]

@Stephen Cobeldick bro , i already tried intersect but i'm not getting what i want. Actually i want to get the full row from cell 2 and this row should havein its both coulmns elements existed in cell1.

clear all
load('cell1')
load('cell2')
c1 =intersect( PPI_data{:, 1},Stage1Exp10_data{:, 1},'rows');
c2 =intersect(PPI_data{:, 2},Stage1Exp10_data{:, 1},'rows');
D=intersect(c1, c2,'rows');

[chocho]

 @Stephen Cobeldick bro, I also tried this code but i want the full row

S= [PPI_data{:, 1} , PPI_data{:, 2}];
[C,ia,ib] = intersect( S, Stage1Exp10_data{:,1},'rows');

Answer 1

[KSSV]

cell1={'gene1';'gene2';'gene3';'gene4';'gene5'} ;

cell2={'gene1','gene3';'gene10','gene100';'gene2','gene5'} ;

out={'gene1','gene3';'gene2','gene5'} ;

[ia,ib] = ismember(cell2,cell1) ;
cell2(ia)

[chocho]

KSSV thanks bro but i have a nested cell-array cell1(259*1) and cell2( both columns of size (39240*1)

[KSSV]

load cell1.mat ;
load cell2.mat ;

cell1 = PPI_data ;
cell2 = Stage1Exp10_data{1} ;

cell1 = [cell1{1} cell1{2}] ;
[ia,ib] = ismember(cell2,cell1) ;
cell2(ia)

[chocho]

@KSSV hi bro, Thanks for you reply but I want to get a row.