Looking for multiple string subjects within excel input array

I have a table composed of string and numerical entries:

I can read the file using: [NUMM, TEXTT, RAWW]=xlsread('FileName,.xls')

In a large file I want to find all the values related to e.g. "Average Velocity on Highway". Now naturally if I search the exact string it will be easy to find the line number associated with this string and the relevant numerical values on that same line. However, I happen to have many files of more or less the same format but every time there are slight differences in the text part of the array (hyphenation, space, special charcters etc.). It will make it difficult for me to have Matlab read a sequence of files automatically. How I can I perform a search where I can say I need to find the index numbers of a line where the words 'Average' and 'Velcoty' and 'Highway' appear?

Answer 1

[KL]

Use readtable! https://de.mathworks.com/help/matlab/ref/readtable.html

It creates a table just like excel (with variable names as well as row names). It is as simple as,

 data_table = readtable('filename.xls','ReadRowNames',true)

[Saeid]

OK, thanks, but how can I search this table for a ro containing two strings?

[KL]

Try the above command and see how the table looks like, Saeid. Then you can access it easily as shown here: https://de.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html