MATLAB: How to search in a text cell by a word

copy cellsdata miningfind a string in a textsearch data

i have a large data (text and numbers), i want to search for a word in a specific cell (contaning text) of a coloumn in all rows. a(:,6)

example

and then copy all the rows containing the word in a new file.

how i can do this ?

i try

j=1 for i=1:size(data,1) if isequal (data{i,6}, ' the word') d(j)=i j=j+i end end newdata=data(D,:);

Best Answer

The standard comparison functions used with numeric variables don’t work with strings. Consider using strcmp or its many friends (most of them linked to on that page). One of them should work for you.

Related Solutions

MATLAB: Find a word in a sentence in a cell

I don’t have your data so I can’t run your code or test this, but see if:

if strcmpi(alldata{i,6},'battery') % search for word "battery"

improves your code.

It uses the strcmpi (case-insensitive string comparison) to do the test.

MATLAB: Search for a word in a cell

It seems that you want to collect together the rows of the file data that contain a particular word (e.g. "Battery"). Here is how you can search particular columns (here I search columns [2,3,4]), how the NaN's can be ignored, and how the rows can be extracted for your output:

X = {'A','Battery','Cheese', NaN;...
     'A','Bison',  NaN,      'Battery';...
     'A','Battery','Battery',NaN;...
     'A','Bathtub','Chalk',  'Duck'};
%
Y = X(:,2:4); % columns [2,3,4]
idx = cellfun('isclass',Y,'char');
idx(idx) = ~cellfun('isempty',regexpi(Y(idx),'Battery'));
data = X(any(idx,2),:)

And the output shown in the command window excludes the rows that do not contain the word "battery" (i.e. the fourth row has been removed):

data = 
  'A'    'Battery'    'Cheese'     [    NaN]
  'A'    'Bison'      [    NaN]    'Battery'
  'A'    'Battery'    'Battery'    [    NaN]

Best Answer

Related Solutions

MATLAB: Find a word in a sentence in a cell

MATLAB: Search for a word in a cell

Related Question