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

6 次查看（过去 30 天）
Justin
Justin 2013-12-4
编辑： Justin 2014-1-6
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
  2 个评论
sixwwwwww
sixwwwwww 2013-12-4
can you show your complete code and your data to ans the question in a better way
Justin
Justin 2013-12-5
编辑：Justin 2013-12-5
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, :) ) );
end
Ultimately, I am trying to go through the rows for each DIR and see what Alerts happen within 36 hours of the DIR.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Walter Roberson
Walter Roberson 2013-12-4
find( ~cellfun( @isempty, YourArray(i, :) ) )
or if you just care whether there is anything non-empty
~all( cellfun( @isempty, YourArray(i,:) ) )
  1 个评论
Justin
Justin 2013-12-9
编辑：Justin 2013-12-10
~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

请先登录，再进行评论。

sixwwwwww
sixwwwwww 2013-12-5
编辑：sixwwwwww 2013-12-9
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;
end
end
end
I hope it helps. Good luck!
  5 个评论
显示 3更早的评论
sixwwwwww
sixwwwwww 2013-12-13
Starting index means DIRs appears in the row given by Row number and at position given by Starting index. So
'Row number' 'Starting index'
4 1
means that string DIRs appears at start(because Starting index = 1) of the in row 4. Is that what you need?
Justin
Justin 2014-1-6
编辑：Justin 2014-1-6
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by