quickest way to scan excel column for keyword

5 次查看(过去 30 天)
say I have an excel column looks something like this:
bacon cooked
3
egg boiled
1
potato fried
30
whats the quikest way to scan the column for the keyword "bacon" and return the cell after it (3) as output?
Thank you!

采纳的回答

Peng Li
Peng Li 2020-4-13
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.

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by