How can I search through a row in a cell array to find strings?

17 views (last 30 days)
I have imported data as a cell array from excel via the xlsread function.
I have searched through the first column in the array using
for i= find(strcmp('string',filename)). This gives me the correct rows that I need to look through to find strings.
How do I search through these found rows to find strings? The array is full of empty spaces and strings. I do not need a specific string, I need any string within that row.
Thank you
Justin on 5 Dec 2013
Edited: Justin on 5 Dec 2013
Here is my code thus far:
%%Import data from spreadsheet
% Workbook: MyDATA.xlsx
% Worksheet: Data Correlation
%%Import the data
[~, ~, MyDATA] = xlsread('MyDATA.xlsx','Data Correlation');
MyDATA(cellfun(@(x) ~isempty(x) && isnumeric(x) && isnan(x),MyDATA)) = {''};
for i= find(strcmp('DIRs',MyDATA));
%Rows=~all( cellfun( @isempty, MyDATA(i,:) ) );
Rows= find( ~cellfun( @isempty, MyDATA(i, :) ) );
Ultimately, I am trying to go through the rows for each DIR and see what Alerts happen within 36 hours of the DIR.

Sign in to comment.

Answers (2)

Walter Roberson
Walter Roberson on 4 Dec 2013
find( ~cellfun( @isempty, YourArray(i, :) ) )
or if you just care whether there is anything non-empty
~all( cellfun( @isempty, YourArray(i,:) ) )
  1 Comment
Justin on 9 Dec 2013
Edited: Justin on 10 Dec 2013
~all( cellfun( @isempty, YourArray(i,:) ) )
seemed to work. It returned a 1 or a 0 for each column that contained a string in the rows labeled DIR.
find( ~cellfun( @isempty, YourArray(i, :) ) )
worked as well. This I believe returned cell numbers for each string within the rows labeled DIRs.
Thank you

Sign in to comment.

sixwwwwww on 5 Dec 2013
Edited: sixwwwwww on 9 Dec 2013
Dear Justin, you can find the occurances of string 'DIRs' in cell array as follow:
[~, ~, MyDATA] = xlsread('filename.xlsx','Data Correlation');
MyDATA(cellfun(@(x) ~isempty(x) && isnumeric(x) && isnan(x),MyDATA)) = {''};
str = 'DIRs';
StringFoundAt(1, :) = {'Row number', 'Starting index'};
count = 2;
for i = 1:size(MyDATA, 1)
row = MyDATA(i, :);
row = row(cellfun(@(x) (~isempty(x)) && (~isnumeric(x)), row));
if ~isempty(row)
idx = strfind(row, str);
idx = idx(cellfun(@(x) ~isempty(x), idx));
if ~isempty(idx)
StringFoundAt(count, :) = {i, cell2mat(idx)};
count = count + 1;
I hope it helps. Good luck!
Justin on 6 Jan 2014
Edited: Justin on 6 Jan 2014
I know which rows contain DIRS in the first column. I was more wanting to find which columns within those DIR rows contain strings, not including the column that is labeled DIRS. Thank you.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!