MATLAB Answers

0

Find text in a variable which contains texts and numbers

Asked by Kelly Kyriakou on 26 Nov 2015
Latest activity Commented on by Kelly Kyriakou on 20 Sep 2016
I read a csv file and store the data in a variable with the readtable command. This variable contains both text and numbers. How I could find the row of specific text?

  0 Comments

Sign in to comment.

1 Answer

Answer by Image Analyst
on 26 Nov 2015
 Accepted Answer

You could use ismember on the column of text, something like
loc = ismember(yourTable(:, 3), 'sometext');
if your text is in column 3. It will return the row the search text is in.

  11 Comments

I converted the csv file to xlsx and try to read in matlab. It reads all the rows (30770) using both xlsread command and readtable command
Kelly, does that mean that your problem is solved?

Sign in to comment.