Azzera filtri
Azzera filtri

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

7 visualizzazioni (ultimi 30 giorni)
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 Commenti
sixwwwwww il 4 Dic 2013
can you show your complete code and your data to ans the question in a better way
Justin il 5 Dic 2013
Modificato: Justin il 5 Dic 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.

Accedi per commentare.

Risposte (2)

Walter Roberson
Walter Roberson il 4 Dic 2013
find( ~cellfun( @isempty, YourArray(i, :) ) )
or if you just care whether there is anything non-empty
~all( cellfun( @isempty, YourArray(i,:) ) )
  1 Commento
Justin il 9 Dic 2013
Modificato: Justin il 10 Dic 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

Accedi per commentare.

sixwwwwww il 5 Dic 2013
Modificato: sixwwwwww il 9 Dic 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!
  5 Commenti
sixwwwwww il 13 Dic 2013
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 il 6 Gen 2014
Modificato: Justin il 6 Gen 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.

Accedi per commentare.


Scopri di più su Structures in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by