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

Question

Justin 2013-12-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/108677-how-can-i-search-through-a-row-in-a-cell-array-to-find-strings

编辑： 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 2013-12-4

can you show your complete code and your data to ans the question in a better way

Justin 2013-12-5

编辑：Justin 2013-12-5

在 MATLAB Online 中打开

MyDATA.xlsx

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.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2013-12-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/108677-how-can-i-search-through-a-row-in-a-cell-array-to-find-strings#answer_117319

在 MATLAB Online 中打开

find( ~cellfun( @isempty, YourArray(i, :) ) )

or if you just care whether there is anything non-empty

~all( cellfun( @isempty, YourArray(i,:) ) )

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Justin 2013-12-9

编辑：Justin 2013-12-10

在 MATLAB Online 中打开

~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

请先登录，再进行评论。

Answer 2

sixwwwwww 2013-12-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/108677-how-can-i-search-through-a-row-in-a-cell-array-to-find-strings#answer_117468

编辑：sixwwwwww 2013-12-9

在 MATLAB Online 中打开

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更早的评论隐藏 3更早的评论

sixwwwwww 2013-12-13

在 MATLAB Online 中打开

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 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.

请先登录，再进行评论。