MATLAB: Finding positions of a partial string in a cell array

cell arrayMATLAB

Hello,
I'm trying to find a way to search through a big cell array (roughly 12,000 x 7) for a partial string, and to get the position of those cells which include that partial string in the array back. In this case, the specific value is '/SH', which can be included as part of a larger string in the cell. I can get another array using strfind(data,'/SH') to return another array marking the cells that have the string I'm looking for, but ideally I'd something that gives me row/column locations of the cells I'm looking for.
Thanks for any help!
Devon

Best Answer

Data={'/SH','abcd','abcd';'abcd','/SH','/SH'}
Data =
    '/SH'     'abcd'    'abcd'
    'abcd'    '/SH'     '/SH' 
[row,col]=find(~cellfun(@isempty,strfind(Data,'/SH')));
[row,col]
ans =
     1     1
     2     2
     2     3
Related Question