Effacer les filtres
Effacer les filtres

quickest way to scan excel column for keyword

25 vues (au cours des 30 derniers jours)
chlor thanks
chlor thanks le 13 Avr 2020
say I have an excel column looks something like this:
bacon cooked
egg boiled
potato fried
whats the quikest way to scan the column for the keyword "bacon" and return the cell after it (3) as output?
Thank you!

Réponse acceptée

Peng Li
Peng Li le 13 Avr 2020
Could try this:
suppose that you don't have a column name
tbl = readtable('yourExcelFile', 'ReadVariableNames', 0);
% N = the column index of that column you mentioned.
ind = find(contains(string(tbl.(N)), "bacon"));
tbl.(N)(ind+1) is what you need.
Note that this is suppose that you always have a number following the string, in case the last one if something that has a bacon field, you won't be able to find anything after that so the tbl.(N)(ind+1) will throw an error.

Plus de réponses (0)


En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange


Community Treasure Hunt

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

Start Hunting!

Translated by