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!
댓글 수: 0
채택된 답변
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!